Running sum in a Stacked Bar Chart

[Stevan_Klaas]

Dear Community,

I am trying to produce a stacked bar chart with a cumulative sum across dates with the customers being the groups :

This is the base data :

In Excel obtaining the underlying table is easily done with pivot running sum on "Booking Year Month" :

However I can't find a use case in the community that does the trick.

Below is the nearest solution I found, it cumulates when there is a data at the intersection of dimensions but it doesn't persist the cumulated amount across the data columns.

Thanks for any help,

Stevan

[Stevan_Klaas]

Found the solution myself :

In the measure properties of the bar chart, use the modifier "Accumulation", but make sure that you :

1 - cumulate accros the X-Axis dimension

2 - Set the range to "full" !!

(Strangely by default the range is "Custom" with 6 steps, which would do a rolling accumulation over 6 axis values...)

[Andrei_Faibich]

I tried to repeat  your solution using the dataset provided and I didn't succeed.

The only solution I found is to restore missed dimension values for each Customer with dummy Sales