Help with setting up a table to display percentages of total

[Anonymous]

I have six columns in Excel. Each column represents a question on a survey. So the column has numbers in it 1-4. Each number representing an answer. I want to display the percentage of the total responses for that column that answered with each question. So for example the % of people that said 1 to Question 1.

I am trying to build a pivot table but my brain just must not be working here. What is the easiest to go about this?

Question	Answer1	Answer2	Answer3	Answer4
Question1	PercentageAnswer1 from Total	PercentageAnswer2 from Total	etc	etc
Question2
Question3
Question4
Question5
Question6

[dplr-rn]

please share a sample of your data.

at a high level try valuelist as a dimension

[achettipalli]

select chart --> use pivot table --> Pick the question column as dimension and expression as count(Answer).  it gives you a drill through table initially. expand it for results.