To work with arithmetic calculations in Tableau, we can either use operators as discussed in the last section, work with one of the many number functions that are present, or make use of some of the aggregation options. This section will cover some of the important functions but it is not an exhaustive list. The Further reading section contains links to an A-Z list of functions maintained by Tableau.
Building arithmetic calculations
Aggregation options
Aggregation options define how your data values are combined or aggregated. Simple aggregation works at the level of visual granularity.
What this means is the data is aggregated at the level of the dimensions in the visual. Without even studying it, we have used this logic...