Top N values Sub-Category Wise in Tableau

Today we’ll be learning how to create how to show Top N values Sub-Category wise in Tableau. The tutorial will be very useful in many context. Please follow the steps below.

Step 1. For the first step we’ll be creating the the basic chart which we’ll be used to show the sub-categories ranking. Place Sales in Columns and Category and Sub category in Rows.

1-min

Now create a Calculated field as shown below.

2-min

 

Step 2. Now Place the Calculated field in Rows and make it discrete.

3-min

 

Now right click on Top N and click on Edit table calculation. Select compute using as Advanced in the Table Calculation window and move Sub-Category to addressing in Advance window and click OK.

4-min

In this step put Top N calculation field in filters and repeat the step for table calculation.

5-min

 

After completing the steps successfully we’ll see that the Sub-Category is showing the values according to the filter.

last-min

So this was easy and very useful tutorial and can be use at many places.

Thanks for reading. Keep visiting Analytics Tuts for more tutorials.

 

 

One comment

Leave a Reply

Your email address will not be published. Required fields are marked *