What I am trying to do is create a table that is visually easier to look at for my company's clients than the pivot table that excel creats. So far, they do like the table, but with the latest requests to make everything more automated, I am struggling a bit with how to write the formulas. I created this sample database so that anyone can see what I mean. Basically, I need the "Strongly Agree" field to pull only the "Strongly Agree" information from the pivot table for that month/year. I got it to where it's pulling the grand total data, but all of the variations I've tried just haven't been working out. It is very possible that I am just completely missing something obvious. Could someone please take a look and let me know what I'm doing wrong or offer some advice on how to make this work?

Obviously this data is really simple compared to what I really need to apply this to. I included the year because the clients want to be able to see different years and compare them (doing that in another area). I just can't get this particular portion of the table to work.

Thanks in advance for any suggestions/feedback/advice!!

SampleBook.xlsx