5 Replies Latest reply on Sep 30, 2018 7:26 PM by meenu choudhary

    Quick Filter

    Seb Bec

      I have a quick filter that creates

      All

      A

      B

      C

      D

       

      Is there a way to customize it and add (may be dynamically)

      All

      A

      B

      C

      D

      B&D

      C&D

       

      many thanks in advance

        • 1. Re: Quick Filter
          Jeff Strauss

          Can you change the filter to a multi-select dropbox?  This may be your easiest option.

           

          • 2. Re: Quick Filter
            meenu choudhary

            Hi Sec,

             

            This can be done by using "Multi Value List" in filter.

             

             

            You can use whatever combination you want using this option.

             

             

             

             

            • 3. Re: Quick Filter
              Mavis Liu

              Hi Seb,

               

              You could create a parameter, I've created one for sub category and have populated it using Sub-Category, then have added in an 'All' Option then also tables and supplies, also phones and storage:

               

              2018-09-26_18h25_39.png

               

              Then I created this calculation and brought it to filters and set it to 1:

               

              if [Multi Select] = 'All' then 1

              elseif [Multi Select] = [Sub-Category] then 1

              elseif [Multi Select] = 'Tables and Supplies' and [Sub-Category] = 'Tables' or [Multi Select] = 'Tables and Supplies' and [Sub-Category] = 'Supplies' then 1

              elseif [Multi Select] = 'Phones and Storage' and [Sub-Category] = 'Phones' or [Multi Select] = 'Phones and Storage' and [Sub-Category] = 'Storage' then 1

              else 0

              END

               

              Please see the attached workbook.

               

              Thanks,

               

              Mavis

              • 4. Re: Quick Filter
                Seb Bec

                Hi Meenu

                All replies were very food,
                I decided to implement your recommendation and got the outcome
                expected.  Many thanks

                • 5. Re: Quick Filter
                  meenu choudhary

                  Thanks Seb.

                   

                  If helped you to solve your problem please mark my answer as CORRECT , so as to close the thread.