topic pivot table Sum on total line in QlikView

pivot table Sum on total line

Wed, 28 Jan 2015 07:54:12 GMT

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 — Wed, 28 Jan 2015 15:30:28 GMT

Hi,

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

I think...

Regards

André Gomes

Wed, 28 Jan 2015 16:37:09 GMT

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.