2 Replies Latest reply on Apr 14, 2018 10:19 AM by samapika tripathy

    Advanced filter on multiple measures

    TheCefi Org

      Hi al,

       

      I need Jedi advise for an advanced filter.

       

      I have the following database. One line per shop, 1 column per service (0 if the service is not offered and 1 if the service is offered).

       

      ShopService 1Service 2Service 3Service 4Service 5
      Shop 110101
      Shop 200111
      Shop 301111
      Shop 411101
      Shop 411011

       

      I want a filter listing all services (how to create it?)

      Filter
      Service 1
      Service 2
      Service 3
      Service 4
      Service 5

       

      If a filter is selected, I'd like to obtain the Nb of shop offering all selected services.

      Exemple, if I select "Service 2" and "Service 4" I will obtain "2" shops as a result (see bellow):

       

      ShopService 1Service 2Service 3Service 4Service 5
      Shop 110

       

      10

       

      1
      Shop 200

       

      11

       

      1
      Shop 301

       

      11

       

      1
      Shop 411

       

      10

       

      1
      Shop 411

       

      01

       

      1

       

      Last but not least, If no filter is selected I'd like to obtain the total number of Shops. (and not the number of shop that are not offering any service).

       

      Any idea on how to configure this specific filter?