Pivot table total caluculation

[Anonymous]

Here in the above pivot table .... i want the  Total and the expression for it is ...

[rubenmarin]

Hi, maybe:

=(if(Dimensionality()<2,

  [Coperate SLP]*Performance

  ))

[Anonymous]

hey i tried but its not coming as a sum .... is there any way to do it done.

[rubenmarin]

Wich result that returns? With a sample I can give more help, anyway you can try:

=(if(Dimensionality()<2,

Column(5)*Column(6)

  ))

[#5]

Hi, give the below a try

=if(Dimensionality()<=1,

  [Coperate SLP]*Performance

  )

hope that helps

Joe

[Anonymous]

nope the total is not correct joe.. help me .

[Anonymous]

thats like the results are help me ruben .... thanks

[Anonymous]

can u give me u r mail id?? so that i can explain the query clearly for u

[linusblomberg]

We need more information from you but basically if I understand you correctly [Coperate SLP] is the column. You can't use that in your total since it weighs differently on every row. What is 5% + 10%? that depends on the associated weight right? 5% of 100 or 10% of 10. I'm having difficulties explaining this in words but you can't base your calculation on that column for a good reason. What is the expression for that column?

[Anonymous]

hey give me u r mail id  . i can send it clearly . or remote me i can show you.