Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have Following table.
Heading | Amount |
---|---|
Gross Sale | 100 |
Discount | 10 |
Net Sale | 90 |
Cogs | 30 |
Gorss Profit | 60 |
I want to create a drill down dimension.
Level 1 As Heading
Level 2 as
If (Heading='Gross sale',Dimension A,
If (Heading='Discount',Dimension B))
But Its Not WORKING ....
PLEASE HELP.
Regards....
Hi Priyal,
I am not sure why it is not working. Is it because -
Level 1 As Heading
Level 2 as
If (Heading='Gross Sale',Dimension A,
If (Heading='Discount',Dimension B)) !
It should be Gross Sale not Gross sale.
PFA the app where it works perfectly fine.
Thanks,
RT
@Thanks Rajesh...
Its working Man...