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:
- Drag-and-drop Customer from Dimensions into the Rows shelf.
- Drag-and-drop Profit from ...
Get Tableau: Creating Interactive Data Visualizations now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.