- Type: Inserted as a column
- Description: Calculates the sum of all values in each row.
- Range:
- Columns: All columns
- Rows: Each row
- Measures: First measure
- Syntax:
sum(all, 0, m1)- Sample crosstab:
Example
Currently we have a built-in total per row, but if we replace the dimension (year) on the horizontal axis with a user dimension grouping different countries, there is no longer a built-in total (this is by design with user dimensions).
The user dimension could be showing different markets like this:
This is a great fit for add Total as a column as shown below.
Comments
Please sign in to leave a comment.