3 Replies Latest reply: Sep 20, 2013 9:41 AM by Yevgeniy Popov

# Hiding the Expression in Pivot table

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,

• ###### Re: Hiding the Expression in Pivot table

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.

• ###### Re: Hiding the Expression in Pivot table

Hi Wassenaar,

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.

• ###### Re: Hiding the Expression in Pivot table

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