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