Accumulation until max Date with dimension Month

[michael_maeuser]

Hi,

I have a Pivot Table with Dimension category and Month.

If I select e.g. year=2013 and i look at April, I need to sum all values until April 2013 (accumulation until the max Date of the Month).

Attached is a sample. I just don´t get it...

Thanks for helping.

BR

Michael

[orital81]

Hi, You can use the Full Accumulated option

but for this you will need to change to straight table.

See attached qvw.

Ori

[michael_maeuser]

No sorry if forgot to mention that this part only refers to some categories (i refer with an if statement). and for all other categories it willt not be accumulated

[orital81]

You can use RangeSum as folowing:

rangesum(above(sum({<Date={"<=$(vTest)"}, Category = {'A'}>} Amount),0,RowNo()))

See attached

[michael_maeuser]

thanks so far,  but it´s only working in straight table. i need that view with the month horizontal because i have many categories