Filter List

A common scenario is having a list of items you wish to research in a PivotTable. You have this list of items in your clipboard, so instead of manually checking each item in the filter dropdown, you can use the Filter List feature from OLAP PivotTable Extensions.

If a field is on rows or columns in the PivotTable, you can right click on one of the members, look under the Filter menu, then select Filter List (a new command added by OLAP PivotTable Extensions):

FilterListMenu.png

Then the dialog comes up where you can paste in a list of items and filter that field to that list of items:

FilterListDialog.png

If a field contains a large number of members, then it may be very slow to drop it onto rows unfiltered. Instead, drop the field onto the PivotTable filters section, right click on the PivotTable, choose the OLAP PivotTable Extensions menu option, then flip to the Filter List tab and select the name of the field in question. Filter to a list. Then move that field to rows. It will maintain the filter you just set and will perform better than showing all members before filtering the PivotTable.

You are limited to filtering fields that are currently in the PivotTable on rows, columns, or filters.

Starting with release 0.7.2, clicking the Show Current Filters button will retrieve the current filters for that field. This is a great way to start from the current set of filters then add or remove a few selections.

Last edited Sep 15, 2011 at 4:15 PM by furmangg, version 7

Comments

iklein Jan 17 at 9:23 PM 
Has the above question from PalPanther been answered? I'd love to know if there is a way to NOT include something. I have a list of 40,000+ customers... and I'd like to EXclude about 16 from my sales reports... and Excel will only display the first 10,000 items.

m9smith Nov 6, 2013 at 7:53 PM 
Is there any way to display the filtered values on the pivot table or spreadsheet without copying and pasting manually from this window? For example if the user applies the filtered members in the list above, can we display that on the sheet so if its printed, people can see the filtered values?

furmangg Mar 1, 2012 at 3:18 PM 
Please vote for the "exclusion list" feature here:
http://olappivottableextend.codeplex.com/workitem/14196

It's on the list but I haven't coded it yet.

PalPanther Mar 1, 2012 at 2:01 PM 
is there any way to add an exclusion list ( i.e. list of items to be excluded from the list ) ??

Thanks