- Go to the top menu, select ‘Analysis,’ then click ‘Create Calculated Field.’
- Enter RANK(SUM([Field])) to rank values based on the selected field.
- Rename the field to “Sales Rank.”
- Click 'OK' to confirm the calculated field.
- Your aggregate data will appear in the Data pane.
- From the Data pane, drag a String(Abc) field onto the Rows shelf.
- Drag the aggregated field (Sales Rank) to the Marks card and change it from Color to ‘Text’.
- A table showing the rank of your selected field will appear.
How to Rank in Tableau
Walk through this interactive demo to learn how to rank in Tableau.
📌 Why this matters
Ranking transforms raw data into competitive insights, letting you instantly spot your best and worst performers without manually sorting through hundreds of rows. You can quickly identify which products drive the most revenue, which sales reps exceed targets, or which regions underperform. Beyond simple identification, rankings reveal performance gaps and distribution patterns—you'll see whether your top performer significantly outpaces others or if performance clusters around similar levels, informing whether you need targeted interventions or broad strategic shifts.
Your product deserves an interactive demo
