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