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
