RangeSum with 2 dimensions

[annick]

Hello,

I have the following dataset:

sales:
LOAD
* Inline [
DCP, Network, NbSales
0, Africa, 1
1, Africa, 1
2, Africa, 1
3, Africa, 1
0, Europe, 2
1, Europe, 2
2, Europe, 2
3, Europe, 2
];

I would like to display the cumulated NbSales by DCP and Network .

I am using the following line chart:

with the measure "Cumulated Sales" defined as follows:

Aggr(RangeSum(Above(Sum(NbSales), 0, RowNo())), DCP, Network)

The above does not work, as I obtain the following result:

I would like to see:

Could you please help me fix the measure "Cumulated Sales" 

Many thanks

Kind regards

[Gabbar]

Add the required Dimensions and add your measure, After that into measure setting use Modifier -> Accumulator and set the amount of preceding steps. 


While if you are having only one Dimension in your chart how do you wish it to show when aggregating on 2 dimensions.

Also please update the picture to show the dimension clearly in the chart you pasted.

[annick]

Hello,

I use this chart and 2 dimensions:

I use this measure:

Aggr(RangeSum(Above(Sum(NbSales), 0, RowNo())), DCP, Network)

I obtain:

The amounts are not cumulated. 

I would prefer to avoid using the setting "Modifier -> Accumulation" . Is there a way to modify the above expression Aggr(RangeSum(Above(Sum(NbSales), 0, RowNo())), DCP, Network) in order to see the cumulated sales?

Thanks a lot

Annick