Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Here in this pivot table i wrote the expression for the Final Performance is like
=if(Dimensionality()>1,
[Coperate SLP]*Performance,
)
i want the total at the bottom as Sum (Final Performance) AS 109+0 =109.
What value do you get on the Total row if you just enable partial sums on the presentation tab for the top level dimension, without including a test on Dimensionality() ?
it is displaying '0' At total .
with this Expression at final performance , then how can i get total ,
=if(Dimensionality()>1,
[Coperate SLP]*Performance,
)
Think your colleague got in there first with this question
http://community.qlik.com/thread/145225
might want to close and focus efforts just on one thread