Help needed on cross column reference in pivot table formula

Mon, 09 Mar 2015 01:59:17 GMT

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!

Re: Help needed on cross column reference in pivot table formula

Tue, 17 Mar 2015 02:41:41 GMT

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

Thanks.

Re: Help needed on cross column reference in pivot table formula

jonathandienst — Tue, 17 Mar 2015 05:38:39 GMT

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

Jonathan

topic Help needed on cross column reference in pivot table formula in QlikView

Help needed on cross column reference in pivot table formula

Re: Help needed on cross column reference in pivot table formula

Re: Help needed on cross column reference in pivot table formula