Pivot Calculated Dimension

[#1]

Hi,

Im trying to show to different fields as a dimension in a pivot table by using the following expression :

=if(match([Indicator Name],'Type 1','Typ2'),[Filter 1], [Filter2])

If the first columns value is either Type1 or Type 2, then the next dimension should hold 'Filter 1' data otherwise is should how 'Filter 2' data.  Is this possible to do?

Thanks,

Fiorano

[#2 · Accepted solution]

the match() function assigns a value of 1 to 'Type1' and 2 to 'Typ2' as you have it written; it isn't a true/false operator.

I would try:

if([Indicator Name]='Type1' or [Indicator Name]='Typ2',[Filter 1], [Filter2]). But no promises.