Cumulative values over the second dimension

[#1]

Hello everyone,

I am facing a problem in a curve chart with 2 dimensions when I want to have cumulative values over the second dimension.

Let me explain :

Dim1	Dim2	Value1	Value2
A	0	10	10
B	0	5	10+5 = 15
B	1	2	2
C	0	8	10+5+8 = 23
C	1	20	2+20 = 22
C	2	25	25

I tried the RangeSum/Above stuff but it only works if I want cumulative values over the first dimension. Moreover, I can't swap the dimensions because of the curve chart.

Thanks in advance for your help !

Damien

[jonathandienst]

Hi

Have you tried Above(TOTAL ....)? This will ignore the second dimension.

Regards

Jonathan

[#3]

Hi Jonathan,

Using Above(TOTAL) , I get :

Dim1	Dim2	Value1	Value2
A	0	10	10
B	0	5	10+5 = 15
B	1	2	10+5+2 = 17
C	0	8	10+5+2+8 =35
C	1	20	10+5+2+8+20 = 55
C	2	25	10+5+2+8+20+25=80

Which is not exactly what I want. I need to keep accumulating datas over the second dimension.

Damien

[jonathandienst]

Damien

I missed that point in your original post. Will have to think about it...

Jonathan

[jonathandienst · Accepted solution]

Damien

Here's my best shot. I used a Pick expression to accumulate for each value of Dim2. The pick expression is compted dynamically from a unique list of Dim2 values.

Have a look at the attached - I think it does what you need.

Regards

Jonathan