Rangesum on dimension values

[#1]

Hi,

I have a table in which I want to accumulate the values. if it was some basic accumulation it would not be a problem, But..

i dont want to accumulate it on the cell above, i want to accumulate it with the cell above that has the same dimension value.

Week	Class	Amount	Cumulative
21	10+	9	9
21	20+	6	6
21	30+	12	12
22	10+	8	17
22	20+	7	13
22	30+	13	25
23	10+	5	22
23	20+	8	25
23	30+	16	41

personally i think i am close to the solution but it needs that last little tweak that I can't figure out.

my expression right now is:

=rangesum(above(sum(Amount),0,rowno(TOTAL<Class>)))

when using the <Class> after TOTAL, the expression fails. but without the <Class> it behaves like normal rangesum which i don't like

[marcus_sommer]

I'm not sure if it could even work but you should rather try to use total and/or set analysis within sum(Amount). I personally would rather choose another chart-design to show the results ...

- Marcus

[dickelsa]

Hello,

I am also looking for the same solution with a similar situation.

Has anyone got an idea?

regards,

Dick

[#4]

I suppose it is not how you normally use the Cumulative function. But i see great potential for end users if this could be realized in some way.