Excel 2007 : Double Filter Problem in Pivot Table Excel 2007

[Azam Ali]

Dear
I am facing an issue in the pivot table filter. Kindy see the attatched file

Kindly first look in the data sheet. There are three types of items in the "Type" column of data sheet i.e. BOARD, N_ROOL & ROOL. However, when I filter the "Plant" filter in the data sheet and select the "OTHER" in the Plant filter, the "Type" filter show only "BOARD " and do not show "N_ROOL" & "ROOL".

Kindly now look into the Pivot sheet. When I filter the "Plant" and select the "OTHER" in the "Plant" filter, the "Type" filter show all three types i.e. "BOARD", "N_ROOL" & "ROOL". I want that Type filter should show only "BOARD" as it shows case of filter in the data sheet.


Kindly support to solve this issue of Pivot Table


Regards

Azam