Help needed on cross column reference in pivot table formula

[#1]

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!

[#2]

Hi anyone can help me on this? Or some other ways to circumvent this situation?

Thanks.

[jonathandienst]

Hi

I suggest that you post a qvw document with a sample of your data and the pivot table that you want modified.

Jonathan