Cumulative line chart

[sanjujeeboy]

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?

[Kashyap_R]

Hi 

PFA

Thanks

[sanjujeeboy]

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

[Kashyap_R · Accepted solution]

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

[sanjujeeboy]

Thanks Kashyap!!

Your solution worked.