Using extended syntax
Besides the regular calculations that we can apply and display in tables, we can use a different kind of calculation that uses contexts to perform the calculation.
The calculation engine of Web Intelligence treats measures in two main ways:
It projects the measure value in the row level. This is what we will normally do with the measures in the report, drag them with dimensions and get their results per the dimension/s values (dynamic aggregative qualification)
It creates a calculation that will display the total, average, min, or max in the table footer as a single cell (a "fixed" aggregative qualification)
Another way to use measures would be to change their context for the following reasons:
We need to display a measure, the level of calculation of which is different from the data level that is displayed
We need to filter the table according to the subtotals (not a simple row filter)
We need to "fix" a value in order to compare it with the rest of the values, such as average...
