Last Modified Date: 02 May 2019
Environment
Tableau DesktopAnswer
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.
Additional Information
Discuss this article... Feedback Forum
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials