In Tableau, a calculated field performs calculations that may be based on other fields. Think of a spreadsheet that has a few columns of data. You may find that you need to create another column to do a calculation.

The Sample – Superstore Excel file has a sheet called Orders. In that Orders sheet there is a Sales and Profit column. To create an Expense column, one would subtract the Profit from the Sales.

Types of Calculated Fields

There are three types of calculations.

• Basic
• Level of Detail
• Table Calculations

There are tow types of Basic calculations.

• Aggregated
• Non-aggregated