Excel Pivot Tables - Getting % of Total for filtered output

I have a filtered pivot table and I want to show the % of the output rows compared to the Unfiltered Total for that row.

In other words, if I am filtering on a Y or N field for field = N and I get an out of 10 and there were 90 with a Y I would like the % of  the 10 versus the 100 total.

Can this be done?

Thanks

glen
GPSPOWAsked:
Who is Participating?
 
Rgonzo1971Connect With a Mentor Commented:
Hi,

you could add a column to your data with the percentage of each element compared to the total then sum it up and change the format to %

Regards
EE20150211.xlsx
0
 
GPSPOWAuthor Commented:
Thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.