

Contributor III
2019-09-19
07:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Exclude value in Dimension
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.
511 Views
2 Replies

Creator
2019-09-19
07:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)
While we teach we learn


Contributor III
2019-09-19
08:32 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you Tilnu,
The problem is the there are too much expression.
Is it possible to solve in the Dimension tab?
492 Views
