Hi, I am still rather a newbie to Pivot, so I hope I can manage to explain this sufficiently:
I have a large data set of multiple choice answers which I am trying to evaluate per year. However since the amount of data records per year differs, I want to look at the percentages to make the data comparable.
So I created a pivot table with multiple items in the value field. But this doesn't give me a total for each year.
Now when I try to activate the option to display the data as percentages of the column total, all cells just show 100%. I assume this is because of the missing column Grand Total.
I attached a sample file where I show the issue. View attachment Pivot Example_Padme.xlsx
Does anyone know how I can solve this?
I have a large data set of multiple choice answers which I am trying to evaluate per year. However since the amount of data records per year differs, I want to look at the percentages to make the data comparable.
So I created a pivot table with multiple items in the value field. But this doesn't give me a total for each year.
Now when I try to activate the option to display the data as percentages of the column total, all cells just show 100%. I assume this is because of the missing column Grand Total.
I attached a sample file where I show the issue. View attachment Pivot Example_Padme.xlsx
Does anyone know how I can solve this?