Pivot table requirement

[kishorj1982]

Hi All,

For one of the expression , I need to show only subtotals not the other values in pivot table column.

Is it possible.

Thanks

[tresesco]

Try like:

Expression: If( dimensionality()=0, <Your Expression>)

or

Expression: If( Secondarydimensionality()=0, <Your Expression>)

[kishorj1982]

Hi Tresco,

Thanks for the response,

Can you please tell me how to show expression values  at 2 dimensionality levels.

I need to, show subtotal at dimensionality level 0 and 3.

Thanks

[tresesco · Accepted solution]

May be like:

If( dimensionality()=0 OR dimensionality()=3, <Your Expression>)