Creating a Pie Chart with Individual Slices for Top N and Single Slice for Other Values

Published: 05 Feb 2013
Last Modified Date: 23 Feb 2018

How to create a pie chart that has individual slices for each value of Top N and a single slice for all remaining values.

Tableau Desktop

The below instructions use Sample - Superstore data to show the top 5 states by profit in a pie chart.

Right-click State and select Create > Set
Name the set Top States by Profit.
Select the following options, then click OK:
- Top
- By Field
- Top 5 by Sales Sum
Select Analysis > Create Calculated Field.
Name the field Top and Other.
Enter the following formula, then click OK:
IF [Top States by Profit] then [State] ELSE 'Other' END
Select Pie on the Marks card.
Place SUM(Sales) on Angle.
Place Top and Other on Color.

All Support