Hi All,
I have a pivot table with dimension of different buckets and datamonth as shown below:
| Datamonth |
| Bucket5 | 201412 | 201501 |
| A.1 | 8% | 10% |
| B.1 | 20% | 16% |
| C.1 | 8% | 10% |
| D.1 | 72% | 14% |
| E.1 | 10% | 247% |
| F.1 | 143% | 0% |
| G.1 | 0% | - |
| H.1 | - | 325% |
The formula I'm using is like
sum
({$<BUCKET5={"B.*"}>}CURROSSGD)/sum({$<BUCKET5={"A.*"}>}CURROSSGD
)
But I would like to use 201501's sum of CURROSSGD in bucket B divide by 201412's sum of CuRROSSGD in bucket A.
Can anyone help me on the formula? below is the sum of CURROSSGD.
| BUCKET5 | 201412 | 201501 |
| A.1 | 866,459,980 | 848,528,960 |
| B.1 | 66,649,661 | 82,298,196 |
| C.1 | 13,271,804 | 12,845,478 |
| D.1 | 1,087,278 | 1,337,087 |
| E.1 | 785,458 | 188,717 |
| F.1 | 75,350 | 465,519 |
| G.1 | 107,553 | - |
| H.1 | - | 107,929 |
| I.1 | 386,129 | 350,289 |
I would like to use 82,298,196/866,459,980. As I have other 11 months from 201401 to 201501 (I'm just showing 2 months here), I need the formula to be used for all months.
Thank you very much!
