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

  ))

[ecolomer]

For the TOTAL Dimensionality is 0

if you question about Dimensionality()=1 never you have a result in the TOTAL (becuase this line is Dimensionality=0)

[Anonymous]

yaa but i want the sum of the above in total how can i make it happen .i tried many expressions .

[SunilChauhan]

goto chart properties-> supress zero values-> uncheck it

[Anonymous]

can u give me u r mailid??

[SunilChauhan]

you could send  message to me using

create-> message. type name in to and write content and sent it. it will be visible to particular recipient

[Anonymous]

actually i tried ..sending u a private message but your name has not appeared there ...

[SunilChauhan]

add as a friend then .you would be able to send message

[Anonymous]

still u r name is not appearing over there...Sunil ... u send me u r mailid ?? i can tel u my query

[simenkg]

=(if(Dimensionality()<=1,

  [Coperate SLP]*Performance

  ))