4 Replies Latest reply: Oct 29, 2010 1:19 PM by John Witherspoon

# Cumulated Values in Bar Chart

Hello,

I have a problem with cumulated values.

(look into the QVW)

Have anybody an idea?

Thanks

Andy

• ###### Cumulated Values in Bar Chart

Hi there,

Try the following expression:

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

Please see the attached file, with your solution.

Regards

• ###### Cumulated Values in Bar Chart

Thank you!

Exactly what I needed.

Things can be so simple ... if you know how! ;-)

• ###### Cumulated Values in Bar Chart

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?

• ###### Cumulated Values in Bar Chart

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.