Hello all…
Here I am coming with an interesting challenge.
It might look simple. Yes, all my challenges are simple. Sometimes you might guess
trick sometimes you may not. Lot of people succeeded in guessing trick for
challenge 16. Now it’s time for challenge 17. I am sure it’s not as simple as
challenge 16.
Note: Surprisingly this is working fine in 9.1 version. It won’t be a challenge in 9.1 version. But when I tried this in 10.1 version I felt it like a challenge.
Look at the data set below. It just monthly
sales data for 2016 and 2017.
Year
|
Month
|
Sales
|
2016
|
Jan
|
50
|
2016
|
Feb
|
45
|
2016
|
Mar
|
60
|
2016
|
Apr
|
65
|
2016
|
May
|
56
|
2016
|
Jun
|
40
|
2016
|
Jul
|
70
|
2016
|
Sep
|
48
|
2016
|
Oct
|
35
|
2016
|
Nov
|
60
|
2016
|
Dec
|
70
|
2017
|
Jan
|
|
2017
|
Feb
|
30
|
2017
|
Mar
|
80
|
2017
|
Apr
|
50
|
2017
|
May
|
60
|
2017
|
Jun
|
70
|
2017
|
Jul
|
50
|
2017
|
Sep
|
60
|
Note:
·
I don’t
have sales for Jan 2017 and Sales data is there till Sep 2017.
·
Copy
and paste above data to solve this challenge.
Below you can see the line graph draw using
given data
I would like to show cumulative (Running
total) sales line chart. You can see below
Now the challenge starts…
You can see that orange line indicates 2017
sales. In data set I don’t have data after Sep month in 2017. As I am doing cumulative
or running sum so it is showing 400 after Sep also. I don’t want to show 400
for all other months which does not have data and orange line should start from
Jan.
So, you should get solution like below.