ExcelBanter - Excel 2007 PivotTable Named Sets as a filter

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

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

- - Excel 2007 PivotTable Named Sets as a filter (https://www.excelbanter.com/excel-discussion-misc-queries/101579-excel-2007-pivottable-named-sets-filter.html)

DaBus11

Excel 2007 PivotTable Named Sets as a filter

How do you utilize named sets as a filter?

For example I want to get the totals on my Top 100 customers but I dont want
to show them. How can I do this?

In the VS2005 Browser I drag them into the "Dimension Filter" area, is there
an equivalent?

All times are GMT +1. The time now is 06:14 AM.