how to calcuate percentage value

[#1]

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