Cumulated Values in Bar Chart

[aerfurt85]

Hello,

I have a problem with cumulated values.

(look into the QVW)

Have anybody an idea?

Thanks

Andy

[#2]

Hi there,

Try the following expression:

rangesum(sum(Qty),above(total column(1)))

Please see the attached file, with your solution.

Regards

[aerfurt85]

Thank you!

Exactly what I needed.

Things can be so simple ... if you know how! 😉

[aerfurt85]

I must correct my answer,

it was exactly what I needed! 😉

Now, the bar chart have to be cumulated.

When I select "Jan-Mrz" and "2008,2009" and check the box "Full Accumulation", the result is what I'm looking for.

But, when I select "Mrz" & "2008,2009" the result must be the same! This Problem I solved.

My Problem is, when I select "Mrz,Apr,Mai" and "2008,2009", the first bar must be the sum of ("Jan, Feb, Mrz"), the second the sum of ("Jan, Feb, Mrz, Apr") and the third the sum of ("Jan, Feb, Mrz, Apr,Mai").

In my imagination, it seems like this:
(File attachment)

Have anyone an idea?

[johnw]

Generate an AsOf table.

AsOfYear, AsOfMonth, Year, Month
2010, 10, 2010, 10
2010, 10, 2010, 9
...
2010, 10, 2009, 11
2010, 9, 2010, 9
2010, 9, 2010, 8
...
2010, 9, 2009, 11
etc.

Replace your chart dimensions with AsOfYear and AsOfMonth. Use sum(Qty) as the expression.