pivot table Sum on total line

[#1]

Here in the above pivot table .... i want the [final performance] Total and the expression for it is ...

=(if(Dimensionality()=1,

  [Coperate SLP]*Performance))

 

in this screen shot . At Final perfromance total should be 109+0 how can i write the expression.

[agomes1971]

Hi,

wrong your total final performance should be 4% + 111%...

I think...

Regards

André Gomes

[#3]

I agree with Andre. I think you must sum the 4% and the 111% percentage in order to evaluate the Final Performance.

Otherwise, you can attach your qvw file in order to help you.

Regards,

T.P.S.