ExcelBanter - Filter on Pivotable

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Filter on Pivotable (https://www.excelbanter.com/excel-discussion-misc-queries/264937-filter-pivotable.html)

tran1728

Filter on Pivotable

Dear All, pls help me.
I work with Pivitable : Iem , Code and Qty.
exemple:
Item Code Qty
1234 10AA 25
1424 25BB 52
1475 10AA 32
1475 514S 14
2300 14CA 8

When I filter code 10AA, i want all Items contains code 10AA and with other
code.
result that i want.
Item Code Qty
1234 10AA 25
1475 10AA 32
1475 514S 14

Thanks for your ASAP.

All times are GMT +1. The time now is 10:38 PM.