I have data that's grouped (in my pivot) first by month, then by person. I have it so at the month level it shows the average across all people (the monthly average for everybody). Unfortunately I want to graph this data by person, so I setup a pivot chart and then filtered to just one person. But doing that causes my monthly average to just equal the number for that one person. Is there any way to filter to one person but still see the average across the whole group?