Skip to main content
Announcements
April 9th: The AI Roadmap: 6 Landmarks for AI-ready Data and Analytics: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
asknyldz
Contributor III

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:

undefinedHello everyone.

 

 
 
 

 

2 Replies
Victor_Alumanah
Creator

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
asknyldz
Contributor III
Author

Thank you Tilnu,

 

The problem is the there are too much expression.

Is it possible to solve in the Dimension tab?