Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Here in the above pivot table .... i want the Total and the expression for it is ...
Hi, maybe:
=(if(Dimensionality()<2,
[Coperate SLP]*Performance
))
hey i tried but its not coming as a sum .... is there any way to do it done.
Wich result that returns? With a sample I can give more help, anyway you can try:
=(if(Dimensionality()<2,
Column(5)*Column(6)
))
Hi, give the below a try
=if(Dimensionality()<=1,
[Coperate SLP]*Performance
)
hope that helps
Joe
nope the total is not correct joe.. help me .
thats like the results are help me ruben .... thanks
can u give me u r mail id?? so that i can explain the query clearly for u
We need more information from you but basically if I understand you correctly [Coperate SLP] is the column. You can't use that in your total since it weighs differently on every row. What is 5% + 10%? that depends on the associated weight right? 5% of 100 or 10% of 10. I'm having difficulties explaining this in words but you can't base your calculation on that column for a good reason. What is the expression for that column?
hey give me u r mail id . i can send it clearly . or remote me i can show you.