I have a Worksheet with multiple columns and rows of data (and I have filters for each column in the worksheet) and I use a pivot table to summarize one of the columns which has multiple items that I need a count for each like item in that column, which is title Source (pivot table shows: CareerBuilder 1, Dice 1, Monster 2, Linkedin 2 with all the rows in the worksheet selected) ... when I filter the worksheet data to show only Sally and Linus' line items, I want that pivot table to show the source totals for only those rows (CareerBuilder 1, Dice 1, Monster 1). Is it possible for a pivot table to do this? Basically change totals dynamically, as the worksheet data is filtered. I have searched and searched and just can't figure it out. TIA, Veronica