Pivot Table

[upaliwije]

Hi,

I have following Pivot Table where I can't calculate the % as I want

PAID_MONTH	PROV_MONTH	PROVISION	Pivot %	Correct %
2015-01	>5 MONTHS	42,561,994	8%	17%
2015-01	2014-09	7,935,724	2%	3%
2015-01	2014-10	14,965,739	3%	6%
2015-01	2014-11	29,029,279	6%	12%
2015-01	2014-12	79,093,410	15%	32%
2015-01	2015-01	75,031,821	14%	30%
2015-01	Total	248,617,969	48%	100%
2015-02	>5 MONTHS	19,259,568	4%	7%
2015-02	2014-10	19,358,724	4%	7%
2015-02	2014-11	12,433,036	2%	5%
2015-02	2014-12	52,992,433	10%	19%
2015-02	2015-01	51,543,303	10%	19%
2015-02	2015-02	117,331,247	22%	43%
2015-02	Total	272,918,310	52%	100%
Total		521,536,278	100%

Expression I have written is follows

SUM(NET_PROVISION)/SUM(TOTAL(NET_PROVISION))

The Pivot % is tne one I get from the Pivot Tbale where as I want % to be calculated as given in last column  (Correct %). Pls help me

[maxgro · Accepted solution]

SUM(NET_PROVISION) / SUM(TOTAL <PAID_MONTH> NET_PROVISION)

[upaliwije]

Thanks a lot