Cumulative sum in pivottable on month - including values before/outside

[#1]

Hi,

Sorry if this already have an answer on the community - I was not able to find it...

I have A pivottable like this

Project	2013-Mar	2013-Apr	2013-May	2013-Jun	2013-Jul
P1	10	20	30	40	50
P2	22	32	33	44	55

And inside I would like to show the cumulative amount used on the project up till the month.

I'm not able to use rangesum and above because I want to include all values before 2013-Mar in the sum.

What to do?

[Anonymous]

This may provide an idea or solution...

http://community.qlik.com/message/329467#329467

[Gysbert_Wassenaar]

You'll have to solve this in the script with an AsOf table. See attached example.

[#4]

Thanks,

Is it possible to do without changing the dataread?

[#5]

I think about something like

sum({<Date<={"date from top of column"}>} Amount)

Would that be possible?

And how do I get the content/date from the top of the column?