Forum Discussion
Row Totals for a pivot table
I have a Pivot table with the following columns: Responses, 0 to 3 , 4 to 6, 7 to 9, 10. For each response in my pivot I have totals under each column. I would like to get a total per response for a...
darkniqht
Advocate I
Advocate I
Go to the Data view or Model view.
Click on the table where your pivot data is located.
In the ribbon, select Modeling and then New Measure.
Enter a formula like this:
DAXTotal Responses = SUM('YourTableName'[0 to 3]) + SUM('YourTableName'[4 to 6]) + SUM('YourTableName'[7 to 9]) + SUM('YourTableName'[10])Make sure to replace 'YourTableName' with the actual name of your table.
After creating the measure, add it to your pivot table or visual, and it will display the total for each response.
The problem with it is the I pivot on the field 'distress scores'. In that field is the 0 to 3, 4 to 6, etc. So I cannot do it before pivotting, I dont believe. When I try after its pivotted, I get the error message ' can only sum on a column reference'.
I am at a total loss!