Get instant live Excel expert help and learn how to show percentage of columns in a Pivot Table
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I have two value field columns in a pivot chart and I need to calculate a third column (percentage). Column A/Column B *100
I can't figure out how to do that outside of copying the values to a normal sheet and doing it manually. I would like to do it within the pivot table so the values update as the data changes.
I have tried calculated fields and I can't get it to work.
Solved by T. U. in 27 mins
I created a pivot table to get the percentage of students who made specific grades in courses. I would like to combine the percentages for specific grades so that the data can tell me which percentage of students made Ds and Fs our fo the total number of students who took the class.
Solved by X. E. in 19 mins