Modification of the dimension in the filter panel

[jonafor25]

I need Dimension1 to display only x, y, in the filter panel.

I already applied the (If) but it changes the name of the dimension and leaves it with the function and goes not allow to change it:

if(Dimension1=x or Dimension1=y) [medida]

Thanks.

[Chanty4u]

try this in filter pane expression  

=if(match((Dimension1),'x','y'),Dimension1)

or you can create in script  :

if(match((Dimension1),'x','y'),Dimension1)  as NewDim 

and use NewDIm as your filter 

[brunobertels]

Hi 

Add this calculated dimension as a master dimension 

if(Dimension1=x or Dimension1=y, [medida] )

Or may be

aggr( if(Dimension1=x or Dimension1=y, [medida] ), medida) 

then give it a name :