Hi. I'm trying to get a filter to work on my pivot table (Excel 2010), and can't it to work as expected. I suspect it might be a simple feature mis-understanding on my part.
When I'm playing around with the PivotTable Field List, I can hover over an item under "Choose fields to add to the report" and a drop menu to appear. If I click on that drop menu arrow, I can set up a filter. Note that I do this but do NOT drag the field to the Report Filter section.
The resulting pivot report does not change (i.e. take into account the filter) although the field list will now show the filter icon. Do I actually have to drag that filter to the filter list for the filter to actually take effect? (If so, why even show that filter icon in the field list the way that I'm doing it now???)
Thanks in advance!
When I'm playing around with the PivotTable Field List, I can hover over an item under "Choose fields to add to the report" and a drop menu to appear. If I click on that drop menu arrow, I can set up a filter. Note that I do this but do NOT drag the field to the Report Filter section.
The resulting pivot report does not change (i.e. take into account the filter) although the field list will now show the filter icon. Do I actually have to drag that filter to the filter list for the filter to actually take effect? (If so, why even show that filter icon in the field list the way that I'm doing it now???)
Thanks in advance!