Hello,

Is there an easy way to programmatically or through formulas to list the labels for the data I have chosen to filter out in a Pivot Table. Example, say I have Year as my Report Filter that contains 2007, 2008, 2009, 2010. But I have only years 2009 and 2010 slected, is there a way I can display somewhere on my sheet so another user who casually looks at the Pivot Table can know that I have exlcuded 2007-2009 in the table?

Thank you very much for the help.