I have this table:
I'm building a bar chart and I need Col1 as the dimension. But I need only values B, C, E, F (say).
How do we use set analysis or filters here?
If we're using filters, the user should not have the freedom to manipulate this selection. At the same time, I need all the values available for other graphs in the sheet.
Thanks in advance!
Solved! Go to Solution.
If you want to have a filter that contains only certain values of the col1, you can create a master dimension as follow:
=if( match(Col1,'A','B','C'), Col1,Null())
and then add it as a filter :