I want to create a slice which looks at multiple conditions across the row.
I have 30 columns of data, of which 18 columns with a condition of Red or Yellow or Green.
I want the slice to only show if any of the columns in show the text Red at least once.
So if column 5 in red and all other columns are Green this would show
if column 10 & 11 is showing red this would also show
but if all columns are green or Yellow this would not show.
I have been looking through the slice categories and not seeing any example of doing this slice.
Can someone help me with this?
Thanks
Solved! Go to Solution.
As the slice row filter:
ISNOTBLANK(
LIST([column1], column2], ..., [columnN])
- {"Yellow", "Green"}
)
As the slice row filter:
ISNOTBLANK(
LIST([column1], column2], ..., [columnN])
- {"Yellow", "Green"}
)
Steve,
So simple when you know
Thank you very much
Wonderful.
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |