Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi friends
I have data like this
Amount_Type Amount
A 800
B 800
B 800
B 900
C 800
I added caluculated Dimention like Amount_Type ='B' and Expression as Sum(Amount).
I am getting only -1 and 0 as Dimentions.
Thanks
Pavan
=if(Amount_Type = 'B', Amount_Type)
I think the above function is giving you the result in boolean format
Hi Pavan,
Try like this in calculated dimension and check the suppress when value is null option
=if(Amount_Type = 'B', Amount_Type)
Regards,
Manideep
=if(Amount_Type = 'B', Amount_Type)
Hi,
Write
wildmatch(Amount_Type,'B',Amount_Type) use this as your calculated Dimension.
And select Supress Null values in Dimension tab
Regards
Hi,
have a look at attached application.
two approaches shown.
Regards
ASHFAQ
Create a Straight Table
Dimension = Calculated Dimension
=Aggr(IF(Amount_Type = 'B',Amount_Type),Amount_Type)
Tick Suppress When Value is NULL
Expression
SUM(Amount)
again its showing 1 and 2 values
Hi,
Its my bad It is like
if(wildmatch(Amount_Type,'B'),Amount_Type)
Regards
have you checked my reply?