15 Replies Latest reply: Apr 5, 2018 3:25 AM by Stefan Wühl RSS

    Market share

    Diego Ivan Hernandez Pioquinto

      Good day to everyone.

       

      I am in a BI project, in this project I have to show the participation of a business in front of its competition, both belonging to the same line.


      Example


      "In an urban area there are 5 record stores:

       

            SHOP A,

            SHOP B,

            SHOP C,

            SHOP D

            SHOP E,

      all these stores represent 100%, but I need to know the percentage of the SHOP A compared to the other stores (these have to be grouped as "Market") so that this way you can read something like this: SHOP A has a participation of 19% against its market which is 81%.

       

      I would greatly appreciate your help.

       

      Thanks