Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
For the below data, is it posible to create a cumulative line chart for each products
Week | Product | Sales |
W1 | A | 7634868.2242838 |
W1 | B | 7651098.6170493 |
W1 | C | 164949644.41754 |
W1 | D | 33869353.592187 |
W1 | E | 12221260.522963 |
W2 | A | 4647233.9256739 |
W2 | B | 8337516.5448516 |
W2 | C | 106175855.70011 |
W2 | D | 23133326.334951 |
W2 | E | 6946136.7327755 |
W3 | A | 4471258.5587391 |
W3 | B | 4565730.3063582 |
W3 | C | 100130134.94571 |
W3 | D | 22303526.399469 |
W3 | E | 5802190.9364665 |
eg for W3 product A should sum all 3 weeks sales.
can it be achieved using line chart?
Hi
I have attached the sample Qvf and iI have created the cumulative measure in the Back end Script
Kindly go through the script and for output go through My new sheet (2)
Hope this Helps
Thanks
Hi
PFA
Thanks
Hi Kashyap,
Thanks for the solution.. it definitely worked.
One more thing. can we show Top 2 Products and show remaining as 'OTHERS' in cumulative line chart.
thanks once again
Hi
I have attached the sample Qvf and iI have created the cumulative measure in the Back end Script
Kindly go through the script and for output go through My new sheet (2)
Hope this Helps
Thanks
Thanks Kashyap!!
Your solution worked.