Predefined Calculations
- Difference between current row and previous row (as a column)
- Difference between current row and previous row (as a measure)
- Difference between first column and second column (as a column)
- Difference between last column and second last column (as a column)
- Difference between two measures (as a measure)
- Difference percentage between current row and previous row (as a column)
- Difference percentage between current row and previous row (as a measure)
- Difference percentage between first column and second column (as a column)
- Difference percentage between last column and second last column (as a column)
- DIV, integer from division (as a column)
- DIV, integer from division (as a measure)
- FLOOR, Floor value (as a column)
- FLOOR, Floor value (as a measure)
- Index first column based on second column (as a column)
- Index last column based on second last column (as a column)
- INT, Integer value (as a column)
- INT, Integer value (as a measure)
- Maximum value (as a column)
- Maximum value (as a measure)
- Maximum value (as a row)
- Median (as a measure)
- Median (as a row)
- Minimum value (as a column)
- Minimum value (as a measure)
- Minimum value (as a row)
- MOD, remainder from division (as a column)
- MOD, remainder from division (as a measure)
- Percentage (as a column)
- Percentage (as a measure)
- Percentage within each hierarchy group (as a column)