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.

       

      Thanks,

      Stefan.