Excel product enhancement request - invert filter selection

Question

As a person who regularly prepares end of month financial reporting within Excel - which includes slicing and dicing data within a pivot table, I would find it extremely helpful if Microsoft was able to include on all its filters, but particularly within a pivot table, the ability to invert the filter selection.

This could just be another tick box below the '(All)' selection as seen below.

Also the ability to filter not only from this filter list but also another external reference list.

These couple of small changes will significantly improve the efficiency of working with pivot charts.

Answer 1

We do not collect feature request or bug in this forum, please have a look here how you can make a suggestion:

How do I give feedback on Microsoft Office? - Office Support

Andreas.

Answer 2

Ok thanks. Feedback has been submitted via the Excel feedback option. 👍

Answer 3

You appear to want to change the list of filters to:-

COSTCENTRETO

DEFERRX

Medication

NHSCOST

PATCAT

Assuming that's the case where:-

DEFERRX

• is at the moment just type in:-

COSTCENTRETO

• then in the next cell below type in:-

DEFERRX

• and so on until your list's inverted.

Does that give you what you want for your first question?

Answer 4

Thanks for your response, but unfortunately, no, it doesn't achieve what I am trying to do. When you have anywhere from 50-200 items (like cost centres) in your filter and you have to capture the filtered totals, then you need to invert the filters to capture of unticked items, it becomes very time consuming. I realise there are some average work arounds that exist. eg create a VBA script to trying achieve this a partial way. I have seen a couple of people do this. However, in the end none of these options are quite as good as just having inbuilt functionality that allows you to tick a box and invert the filter selection. I am quite confident that many people who use pivot charts to manipulate slice and dice data would find this functionality very useful. (as would being able to map a reference data set to a filter so that you don't have manually select a range of filters at the end of month, when doing end of month reporting. Would be a big time saver and a much needed feature. But I have since responded as suggested above and provided these comments to the feedback location within the excel application.

Thanks again :)