Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

pivot table issue

mon.PNG

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.

Labels (1)
3 Replies
Colin-Albert
Partner - Champion
Partner - Champion

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() ?

Not applicable
Author

it is displaying '0' At total .

with this Expression at final performance , then how can i get total  ,

=if(Dimensionality()>1,

  [Coperate SLP]*Performance,

  )

Not applicable
Author

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