Pivot table total

[Anonymous]

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

=(if(Dimensionality()=1,

  [Coperate SLP]*Performance

  ))

[simenkg]

Just post it here...?

[Anonymous]

the expression for ,

Coperate Slp and performance is of 100 lines such so problem, and how can we write it??

[simenkg]

Simplify your expression and test that you are getting the expected results on your Total-line, and then expand from there.

I have given you the answer and will not help any further, as this has taken enough of my time. If you cannot get this to work yourself then I suggest hiring a QlikView consultant to fix it for you.

[Anonymous]

i m trying since a week and heartfull thanks for sparing u r time simen.