Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Exclude value via a slicer

Hi,

 

I'm making a sales report and I want to exclude sales orders based on a characteristic.

 

Let say that every order can be categorized as A, B or C.

 

Example:

 

Sales order 1 | A

Sales order 2 | B

Sales order 3 | C

Sales order 4 | A.

 

Now I want to make a filter with two options, either 'showing all orders'  (in this example 4) or 'showing all orders except A' (in this example 2).

 

Can you help we with this?

 

Thx!

2 Replies