Implement cumulative sum in pivot table

[swarup_malli]

Hi,

I have a Pivot table which uses advanced set analysis

It has been converted into a cross table.

Currently the Table looks like this (see fig below)

The resulting chart table should look like (see below)

!

[petter]

[swarup_malli]

Thanks for the response Petter

I was looking for cumulative sum ,the app You attached has a calculated dimension

[sunny_talwar · Accepted solution]

This seems like what you want:

Expression:

=RangeSum(Before((Sum({<REPORT_YEAR={2014}>}FLIGHT_HRS)/COUNT({<REPORT_YEAR={2014}>} AC_SERIAL) * COUNT({<REPORT_YEAR={2014}>} AC_SERIAL)) -

Before(TOTAL (Sum(FLIGHT_HRS)/COUNT(AC_SERIAL)) * COUNT(AC_SERIAL)), 0, 2))

Also attaching your qvw for reference.

Best,

Sunny

[swarup_malli]

Wow !

That was some serious advanced analysis

Great Job ! my friend

[sunny_talwar]

I did not do much there, just used your expression and wrapped around it the RangeSum(Before()) function..., but I am glad we were able to figure it out.

Best,

Sunny