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...
Not sure the data needs to be pivoted.
If the data is unpivoted and you have two columns A is 0..10 and B is number of responses for each of A.
Sum(Column B)
Would need to see the original table? If the above assumption is incorrect.
Onwards and Upwards!