Pivot Table Filters

[mICKbRusSels]

Hey there,

I have a basic Pivot table in an ExcelSheet. Outside my pivot table (in the next column) I've some comments related to each row. What I want is to be able to hide the entire row of my sheet when i filter a column of my pivot table.

So when i select the 'Element 1' in my pivot table, I only want the comments regarding this element.

I use Excel 2007 and the filter option only works within the pivot table.

I hope it's clear !!! Any suggestion ?
Many Thanks

Mick