Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to exclude "Alfa" team in my pivot table. I need to see only Beta and Charlie values. What should i write in the "Enable Conditional" exactly?
Here is the "Team" list:
Alfa
Beta
Charlie
and here is the my Dimensions Tab:
Hello everyone.
Hi there,
If you do not have many expressions, one option would be to use one of the examples below in the expression area.
Count({$<Team-={'Alfa'}>}AMOUNT)
Sum({$<Team-={'Alfa'}>}AMOUNT)
Thank you Tilnu,
The problem is the there are too much expression.
Is it possible to solve in the Dimension tab?