I have data like this
I added caluculated Dimention like Amount_Type ='B' and Expression as Sum(Amount).
I am getting only -1 and 0 as Dimentions.
I think the above function is giving you the result in boolean format
Try like this in calculated dimension and check the suppress when value is null option
=if(Amount_Type = 'B', Amount_Type)
wildmatch(Amount_Type,'B',Amount_Type) use this as your calculated Dimension.
And select Supress Null values in Dimension tab
again its showing 1 and 2 values
Its my bad It is like
have a look at attached application.
two approaches shown.
Create a Straight Table
Dimension = Calculated Dimension
=Aggr(IF(Amount_Type = 'B',Amount_Type),Amount_Type)
Tick Suppress When Value is NULL
have you checked my reply?
Retrieving data ...