Cumulative Values in Pivot - Acumulating Specific Dimensions

Thu, 14 Oct 2010 11:45:56 GMT

Hi Folks

I have a pivot Table with Month & Business Unit as dimensions.

I have a Capital Amount value for each month.

I then want a cumulative capital amount column, but it must accumulate for the specific business unit.

EG:

Month	BU	Capital$	Cum Capital
1	Global	100	100
1	Inv Bank	200	200
1	Retail	150	150
2	Global	220	320
2	Inv Bank	130	330
2	Retail	450	600
3	Global	300	620	Cumulative sum of Global
3	Inv Bank	220	550	Cumulative sum of Inv Bank
3	Retail	180	780	Cumulative sum of Retail

Any help would be appreciated.

Cumulative Values in Pivot - Acumulating Specific Dimensions

johnw — Fri, 15 Oct 2010 01:30:35 GMT

You could generate an AsOf table:

AsOfMonth, AccumulationType, Month
1, Capital, 1
2, Capital, 2
3, Capital, 3
1, Cumulative Capital, 1
2, Cumulative Capital, 1
2, Cumulative Capital, 2
3, Cumulative Capital, 1
3, Cumulative Capital, 2
3, Cumulative Capital, 3

Use AsOfMonth in place of Month as the first dimension. Add AccumulationType as the third dimension. Sum(CapitalAmount).

topic Cumulative Values in Pivot - Acumulating Specific Dimensions in QlikView

Cumulative Values in Pivot - Acumulating Specific Dimensions

Cumulative Values in Pivot - Acumulating Specific Dimensions