Scenario 30: Show Monthly Sales trend for Top 5 States by current month sales.


Generally, in organizations you will get similar kind of single line problem statements. It’s important that how you will understand this problem statements and convert them into meaningful insights. Usually I will convert problems statements into simple logic steps. Then I will start thinking about how to solve them using technology. 

Here the above statement, I will convert into following steps.

Step 1:
Find current month sales

Step 2:
Identify Top 5 states by current month sales

Step 3:
Show monthly sales trend for Those Top 5 Sates.

Now we will see how to do these steps in tableau.

Step 1:
We will write calculation filed for current month sales. Later we can use this calculation to find Top 5 sates by current month sales. 


Step 2:
This Step you can do in two ways.

Method 1:
Using Top option in Filter selection. 


Method 2:
Using Sets in tableau. Create a top 5 States set by Current month sales. 


Step 3:
Finally show monthly trend for those Top 5 sates.

Method 1:

Method 2:

This is how I solve problems in tableau. I like steps approach in problem solving.