Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Here in the Attached Pivot table ,
I required to calucualte Final Performance Line,
It should be , at
Dimensionality=1,
CLP * Performace
Dimesionality =0,
Total of that above line .
But,when i select each states it should give relative individual Percentages.
PFA,
Thanks in advance,
Hirish
Hi Hirish,
I cant open your qvw now. Not sure but just try.
sum(TOTAL (<CLP> * <Performance>))
I tried but not working like that,
Thanks for your Reply .
Hirish
Change your Final Performance expression as below..
Column(6) * Column(7)
Hi Manish ,
I tried that way too.
Help out with aggr .
Thanks for your response.
HirisH
Is this ?
Hi Enrique,
Total for that line also to be displayed . Like Screen shot.
Thanks For Your Response,
Hirish
Hi i worked around your file and sharing this file. IN that file For Jan its not showing total becoz clp have total and perfomance dont have total as per our expression its multiplying so its giving null.For Feb its giving.
Plz go through it and let me know
Regards,
Ngarjuna
Hi,
i want to display final total for the Final performance itself . as per the screen shot .
Thanks for your response .
Hirish
In my above reply its showing for Feb, For Jan Becoz null in Performance its not showing
Nagarjuna