Hi,

I am using a pivot table to summarize some data for a report. I'd like to take the raw numbers and present them as a % of the whole. The pivot table has a total "interactions" that are broken down by "likes" and "comments" in separate columns. What I'd like to see are comments and likes presented as a % of the total interactions.

This is the data
Name Interactions Comments Likes
alpha 50 5 10
beta 100 5 10

This is how I'd like the Pivot Table to summarize the data
Name Interactions Comments % of Interactions Likes % of Interactions
alpha 50 10% 20%
beta 100 5% 10%