Pivot table: show sum for desired expressions only

[#1]

Hi,

I have a pivot table with 5 expressions and i want to show total for 3 expressions only. How can i achieve this please?

Following possibilities are not feasible for my requriment:

1. Use Straight table instead of Pivot.

2. Move the 2 expressions as dimensions.

Any suggestions ?

[marcus_sommer · Accepted solution]

You could exclude these calculations with dimensionality(), like:

if(dimensionality() = YourDimensionlevel, YourExpression, '')

- Marcus

[its_anandrjs]

Hi,

What if you use a expression is like suppose there is 5 expression and for 2,3 and 4 need the sum total expression in another column then write this way for nest expression.

=Column(2) + Column(3) + Column(4)

Regards

Anand

[alexandros17]

Add dimensionality() as expression, verify the number it returns as total and use that number in the expression:

if(dimensionality()=yournumber, YourExpression, 0)

let me know