...
Tip | ||||
---|---|---|---|---|
| ||||
By default, when a custom expression is applied to a pivot table, the calculation will be aggregated against each unique set of values that are being grouped on. However, in some cases you may want to compare these aggregates with an overall aggregate. You can refer to the overall aggregate of any metric by including the word "Overall" at the beginning of the name. In this example, this calculation will be aggregated according to how the expression is applied to a pivot table:
Now in this example, we explicitly desire to use the overall average score, regardless of how this expression is being grouped within a pivot table:
|
...