Deactivate 'Select Multiple items' in a pivot table filter

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3135680%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EDeactivate%20'Select%20Multiple%20items'%20in%20a%20pivot%20table%20filter%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3135680%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHi%2C%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20was%20wondering%20if%20there%20is%20a%20way%20to%20deactivate%20the%20'Select%20Multiple%20items'%20in%20a%20pivot%20table%20filter%3F%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EThis%20is%20to%20help%20ensure%20that%20the%20user%20has%20a%20no%20option%20to%20select%20multiple%20items.%20I%20know%20this%20can%20be%20done%20as%20a%20slicer%20however%20in%20my%20situation%20using%20a%20slicer%20is%20not%20an%20option.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F346172i6C473FD950331476%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22lucioxiii_0-1644314050848.png%22%20alt%3D%22%5C%26quot%3Blucioxiii_0-1644314050848.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EMany%20thanks%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3135680%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Contributor

Hi,

 

I was wondering if there is a way to deactivate the 'Select Multiple items' in a pivot table filter?

 

This is to help ensure that the user has a no option to select multiple items. I know this can be done as a slicer however in my situation using a slicer is not an option.

 

lucioxiii_0-1644314050848.png

 

Many thanks

1 Reply

Here is a work-around:
- Insert a slicer for that field
- Copy the pivottable to a separate worksheet where you drag that field to the row-area and delete all other fields from the pivot table
- Set the Report connections of the slicer to both pivot tables
- Suppose your new pivot table is on Sheet3 and the new pivot is in column A
- Add this formula next to the "Provider" filter, next to the cell that currently says "(All)":
=IF(COUNTA(Sheet3!A:A)>2,"Please select only one item!","")

See attached