- In your worksheet, open the 'Analysis' menu then choose 'Create Calculated Field'.
- Enter your formula for the Percentage as: enter a formula such as SUM ([field])/TOTAL(SUM([field]))*100.
- In this tutorial, we will calculate the Percentage of Sales. Formula: SUM ([Sales])/TOTAL(SUM([Sales]))*100
- Change the field name to ‘Percentage of Sales.’ Then click 'OK'.
- Your aggregate data will appear in the Data pane.
- You can drag your aggregate data to the Rows or Columns shelf along with your other fields to view the Percentage data.
How to Calculate Percentage in Tableau
Try this interactive demo to learn how to calculate percentage in Tableau.
📌 Why this matters
Calculating percentages transforms raw numbers into meaningful insights that reveal performance patterns and drive strategic decisions. You can instantly identify which products, regions, or time periods contribute most to your total results, making it easier to allocate resources and set priorities. Beyond simple comparisons, percentage calculations enable you to create compelling visualizations that stakeholders immediately understand, eliminating the need for mental math when presenting findings. This foundational skill becomes essential when building dashboards that tell clear data stories.
Your product deserves an interactive demo
