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