I am not sure how to word so apologize if the title is confusing.

Please see attach image. I want to create a pivot table that looks like the table I created manually. I want to see Total # Priority and how many of they are automated (in %). I tried hiding/filtering the "Not automated", then when I did that total did not match.

Thank you in advance.

pivot.png