Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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