Using '% of' provides #N/A. How do I calculate?

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%

Rather than show Likes and Comments in the pivot, just show Interactions and add two calculated fields (Pivottable Tools>Options>Fields, Items & Sets>Calculated Field) called Comments % of Interactions and Likes % of Interactions with formulas of

= Comments / Interactions

and

= Likes / Interactions

and format them as percentage.

Thanks this solved my problem.