Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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.

3 Replies
Colin-Albert

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