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

  ))

[Anonymous]

After

=(if(Dimensionality()<=1,

  [Coperate SLP]*Performance

  ))

its like this ..Actually i want the sum of 109+0

As 109 to be appeared over there .

[simenkg]

if(Conditionality() = 0,

     sum(Aggr(avg([Coperate SLP])*[Performance]),Group))

     ,  

if(Dimensionality()=1,

  [Coperate SLP]*Performance

  ))

)

[Anonymous]

i m not able to place this expression will you help by remote .....

[simenkg]

No.

You put that as the expression called Final Performance.

The reason it might not work is because you are referencing another column. Replace the [Coperate SLP] and [Performance] with the actual expressions used to calculate them.

[Anonymous]

Actually there i want to display sum of the values which got to be obtained in Final Performance .....

avtually if u see u can get it i think

[simenkg]

I understand, but if you want the sum of Final Performance shown on the Total line for Final Performance, then you have to use the whole expression as the expression for Final Performance.

If(Dimensionality() = 0,

     Then we do this calculcation for the Total line,

     if(Dimensionality() = 1,

          Then we do this calculation or the sub total line

     ,

          Then we do this calculation for every normal line

))

[Anonymous]

yes i have tried many like that but i m not getting result and fed up with it ...can u c through remote once please

[simenkg]

I am sorry, but I will not.

Create a new expression that is just:

Dimensionality()

Create another that is:
SecondaryDimensionality()

Then in your IF()-statement use the combination of the two that appears on your total line.

[Anonymous]

can i send u the expressions of [ corporate Slp ]  and Perfromance .

ya write expression i tried many so.

[Anonymous]

can u please help me to write expression .