Mandatory Single Select Filter


I made a Pivot Table which needs 3 Single Select filters to be done by the user, otherwise it will be summing the values (which I don't want to happen because it will show the data incorrectly), so the only way to make it completely proof of human errors is making these mandatory, but I can't find this feature.

I saw this post from May 2020, but it doesn't look as it had any updates on this feature regarding this topic:

Have they added this feature somewhere? If not, is there any workaround I can do to deal with this issue?



  • MichelleH

    If you click the gear icon on any of your quick filter fields in Analyzer, you can change it from Multi select to Single select.

  • GrantSmith


    They still haven't implemented this. The current workaround is to utilize a beast mode to display an error if not all the filters are selected (you can use a COUNT to check for duplicates / unfiltered data). You could do this on a page or possibly as the summary number to display "SELECT X, Y and Z filters"

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • Douglas_Digon


    Thanks for your answer. It worked like a charm!