chart with running sum and %

[lucarizziero]

Hi,

I have the following data

Customer	Month	Qty
A	1	2
A	2	3
A	3	4
B	1	12
B	2	13
B	3	14

I’d need to obtain a chart containing for each customer+month the % of the total qty in the year.

For instance:

Customer	Month	Running qty	Total qty per Customer	%
A	1	2	9	22%
A	2	5	9	56%
A	3	9	9	100%
B	1	12	39	31%
B	2	25	39	64%
B	3	29	39	100%

the Line Chart will have x=month and y=customers with 2 lines representing the % column

Thanks

[whiteline · Accepted solution]

Create straight-table chart with two dimensions (customer, month) and try these expressions:

Running qty =rangesum(above(Sum(qty),0,rowno()))

Total qty per Customer =SUM(total<customer> qty)

% = rangesum(above(Sum(qty),0,rowno()))/SUM(total<customer> qty)

[lucarizziero]

It works !:

Thanks a lot