Hey Mrneski! See new attached image in original post
Thank you for the reply. Your file works and is exactly what I wanted. However, I have updated my actual excel format so that the two pivot tables are merged together (completed & planned) show in one pivot table. This is done by first filtering the columns to show "Completed Early" and "Planned" tasks. Then each of those is filtered by "Percent_Complete".
I still want the same summary table you worked on.
Issue: I am having trouble manipulating the
code. I now need to get the same data but do it by referencing two column filters. Attached you will see the set up with the two filters. Question: How do I get to the 12, 8 and 32 shown in the picture? Thanks!!!!
Snippt.PNG
Bookmarks