Do you feel that you are Tableau Expert? Then try this challenge 17

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.


 For more challenges: Click Here
Experiment… Observe… Learn…