So, I have a need to show all values for a Division of a Category, regardless of sales. Say my data set looks like the below...
If my dimension in the cyclic is "Category", I get all five. Perfect.
If try to show all Division=1, I only show A and C - likewise with Division=2, I only get D. This is because the table is accumulating sales from items and there are no items sold. Expression: =if("Division"='1',"Category")
I want to show A, B, and C if I select Division=1 and D and E when selecting Division=2.