Quick Table Calculation is an option available with a right-click on every Measure. It automatically changes the Measure to a Calculated Measure using a Table Calculation function. You can find very interesting functions among the table calculations list; running sum, rank, difference, percentage of total, and more, all available with a right-click. Being able to automatically use those calculations with a simple right-click is extremely useful.
As an example, let's compare, for each year, the cumulative sales by quarter using the Sample - Superstore Data Source:
- On a blank Worksheet, add Order Date in Columns and Sales in Rows.
- Click on the + button next to the YEAR(Order Date) pill to open the quarter to add to. The visualization should look as follows:
- Right-click on Sales, go to Quick-Table Calculation, and select Running Total. What you see is the running total of the sales among all years and quarters.
- Put the YEAR(Order Date) pill in Color. It's now very easy to see which year ends with the most sales generated at the end of the year; you can observe this in the following screenshot:
To finish with table calculation functions, let's see another example.