Hi,
I am facing problem in calculating percentage value. Please see attachment. I have 2 pivot table; Tertial and Tertial-1. I have to calculate ratio in Tertial-1 table based on Tertial total(for each HI, MI and Others value).
For e.g. if i take Q4 2014:
HI% = 110/413*100
MI%= 192/413*100(which i am getting correct in Tertial-1 table as 46.49%)
Others= 111/413*100
But I'm getting % value only for MI and not for HI & Others. Can anyone help me how to get those values ?
FYI: In Tertial-1 I'm using below expression for Ratio
sum({$<Month_Key = {"<=$(=min(Month_Key) - 100)>=$(=max(Month_Key) - 100)"}>}[Invcd. qty])/aggr(sum({$<Month_Key = {"<=$(=min(Month_Key) - 100)>=$(=max(Month_Key) - 100)"}>}[Invcd. qty]),Quarter)
Note: I have used month_key & month_key-100 to display last 12 months data only(that's how my application is).
Any help is much appreciated !
Thanks,
Roushan
