Advanced functions
There are two types of functions that are a bit different: Table Calculation and Level of Detail.
Table Calculation
The Table Calculation functions are special in many ways. Mastering them requires practice, but they are very useful. It's important to understand how they work and how to use them. Let's start slowly by using an awesome option called Quick Table Calculation.
Quick Table Calculation
Quick Table Calculation is an option that becomes 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 Quick Table Calculations list: Running Sum, Rank, Difference, Percentage of Total, and many more—all available with a single right-click.
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 to Columns and Sales...
