Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
I have one situation,
I am using pivot table , and it has 3 dimensions and one expression.
But i want to hide those rows which are null at the top level it is working fine like if i found null values in 2nd dimension this will work fine but if i got null value in 3rd dimension it is chaging my second level dimension total.
Can ypu please help me out here.
Thanks
What is the expected output here?
If i am suppressing null in 3rd column it will also suppress their respective number .
But i want here if i group at second level sum should 220 but if i un group 2nd level it should not show 130 value.
Can you check now
=If(Dimensionality() = 2, Sum(four), Sum({<five = {'*'}>}four))
thanks but at the first level sum should be 300 for B
Sunny,
Just for my knowledge purpose, What does the '*' represent ?
I thought you would be able to play around with it to make it work according to your requirement.
Check this out
=If(Dimensionality() = 3, Sum({<five = {'*'}>}four), Sum(four))
It means include all those five where they are not null
Thank you.
Hi Agnivesh
Try something like this-file attached.