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
Bookmarks