ExcelBanter - Pivot Table Filter

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

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

- - Pivot Table Filter (https://www.excelbanter.com/excel-discussion-misc-queries/76898-pivot-table-filter.html)

Lisa

Pivot Table Filter

Excel 2003 show a filter arrow on data rows, to select/deselect single items.
Can I apply custom settings as you can on Autofilter.
I want to show data only of product codes containing "FG" not for all
product codes.

Dominic

Pivot Table Filter

If I understand you correctly, trying using the "Page Field" functionality.

"Lisa" wrote:

Excel 2003 show a filter arrow on data rows, to select/deselect single items.
Can I apply custom settings as you can on Autofilter.
I want to show data only of product codes containing "FG" not for all
product codes.

All times are GMT +1. The time now is 10:01 AM.