I'm sure some people have this kind of requirements. Based on some filter condition I need to exclude only Sub-category=Accessories for Category=Technology and Segment=Consumer.
How about adding a calculated field to the filter shelf and selecting 1
I tried below method and work as expected.
IF [Segment]="Consumer" and [Category]="Office Supplies" THEN (if [Sub-Category]="Appliances" THEN 0 else 1 end) ELSE 1 end
IF [Segment]="Consumer" and [Category]="Furniture" and [Sub-Category]="Chairs" THEN 1 ELSE 0 END
Please mark this as answered
Retrieving data ...