Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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 )