Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
guibsantos
Contributor II
Contributor II

Filter Pane selections

Hello Comunity, 

I have a pivot where I have as a dimension column a field called 'Scenario' which fields are (A20, A21, A22, B20..)

I am using at the same time a filter pane for Scenario and I would like to restrict the selections to just 2, which would give me a maximum number of 2 columns for the pivot.

How can I do this for the filter Pane?

 

Thank you a lot!

Labels (2)
1 Reply
PradeepK
Creator II
Creator II

I think what you want is calculated column dimension in pivot table. To restrict columns to only 2 dimension values.

Use simple if condition in dimension field and hide null values

if( Scenario = 'A20' or Scenario = 'A21' , Scenario )