Hiding the Expression in Pivot table

[#1]

Hi,

I want to hide some of the expressions based on the level of expand dimensions.

when everything is collapsed i need to show only some of the expressions and when its expanded to next level i need to show all the expressions.

i tried with dimensionality function, but its not helping me.

could anyone help me to resolve this problem,

thanks in advance.

[Gysbert_Wassenaar]

What you want is not possible with a pivot table. There's no way to know (other than using your eyes) to know what is expanded or collapsed.

[#3]

Hi Wassenaar,

Thanks for your reply.

I think its possible to find the level of expanded using dimensionality() or secondarydimensionality function.

I dont know how yo use that functions in conditional location. i can able to use dimensionality in expression tab. its working fine.  but in conditional, its not working.

[yevgeniy]

Hi Gopinathan,

May be i do not  understand you question .

But, conditional is work:

if(Dimensionality()<3,

Sum ({$<PYD= {2} , Date2 = {'<=$(vVitorg)'}>}[Sales])-Sum ({$<PYD= {2} , Date2 = {'<=$(vVitorg)'}>}[Sales]),

if(Dimensionality()<5,

    Sum ({$<PYD= {1} , Date2 = {'<=$(vVitorg)'}>}[Sales(чеки)])-Sum ({$<PYD= {1} , Date2 = {'<=$(vVitorg)'}>}[Sales]),

        Sum ({$<PYD= {1} >}[Sales]) - Sum ({$<PYD= {1} >}[Sales]))