Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
You could exclude these calculations with dimensionality(), like:
if(dimensionality() = YourDimensionlevel, YourExpression, '')
- Marcus
You could exclude these calculations with dimensionality(), like:
if(dimensionality() = YourDimensionlevel, YourExpression, '')
- Marcus
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
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