- Type: Inserted as a measure
- Description: Calculates each row value as a percentage of the total of all row values, in each column.
- Range:
- Columns: Each column
- Rows: Each row
- Measures: First measure
- Syntax:
if sum(0, 0, m1) = 0 then 0 else sum(0, 0, m1) / sum(0, all, m1)
- Sample crosstab:
Example
Adding Percent (measure) will make the table look like this:
Comments
Please sign in to leave a comment.