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. ...
