Cumulative Values in Pivot - Acumulating Specific Dimensions

[#1]

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.

[johnw]

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).