Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi anyone can help me on this? Or some other ways to circumvent this situation?
Thanks.
Hi
I suggest that you post a qvw document with a sample of your data and the pivot table that you want modified.
Jonathan