Hide null rows at each dimension level in pivot table

[agni_gold]

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

[sunny_talwar]

What is the expected output here?

[agni_gold]

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.

[sunny_talwar]

Can you check now

=If(Dimensionality() = 2, Sum(four), Sum({<five = {'*'}>}four))

[agni_gold]

thanks but at the first level sum should be 300 for B

[trdandamudi]

Sunny,

Just for my knowledge purpose, What does the '*' represent ?

[sunny_talwar]

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))

[sunny_talwar]

It means include all those five where they are not null

[trdandamudi]

Thank you.

[ankit777]

Hi Agnivesh

Try something like this-file attached.