Showing the top 10 items

At times, it is just easier to view the top 10 items by a certain measure, such as the top 10 most profitable customers or the top 10 least expensive vendors, rather than viewing all the items of a field. This approach, although easier, must be used with caution since anomalous items or patterns could be missed by viewing only the top n or bottom n items.

Getting ready

Let's use the sample file Sample – Superstore Sales (Excel). Open a new worksheet and select Sample – Superstore Sales (Excel) as the data source.

How to do it...

Once the data is loaded, perform the following steps to view a table with the top 10 customers by total profit:

  1. Drag-and-drop Customer from Dimensions into the Rows shelf.
  2. Drag-and-drop Profit from Measures into the Text input box under Marks.
  3. Drag-and-drop Customer from Dimensions into the Filters pane.
  4. Click on the Top tab in the Filter [Customer] options box.
  5. Check the By Field option.
  6. Make sure your options (top 10 by Profit and aggregation is Sum) look like the one in the following screenshot:
    How to do it...
  7. Click on OK.
  8. To sort the customer list in descending order of profit (that is, the most profitable customer up at the top), click on the Sort button that has the longest bar up at the top and a down arrow to its right, as shown in the following screenshot:
    How to do it...

How it works...

Tableau not only provides filtering by item names, but also provides filtering by aggregate measures such as limiting to top or bottom items by sum, average, and other aggregations.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset