3 Replies Latest reply on Jul 17, 2018 9:22 AM by Shinichiro Murakami

    Quick Filter with a dynamic (All) option using a parameter

    Stefan Hanotin

      Hi all,


      I have a Units/Revenue parameter that allows me to view either units or revenue of a product per year.


      I have a dynamic quick filter by having a True/False field that is always TRUE and using 2 sets that are based on the parameter.


      I want to remove the option of "All" if the parameter is Units but to include the option of "All" if the parameter is Revenue.


      Attached is a workbook with a sample of what I have.


      Any help would be greatly appreciated.