2 Replies Latest reply on Jun 11, 2013 12:56 AM by Alejandro Barreras

    Grouping data and obtaining remaining percentages dinamically

    Alejandro Barreras

      Hello All,

       

      I'm trying to do the following:

       

      Imagine that you are working inside the Telecom Market. you have AT&T, Verizon, Vodafone and Orange. AT&T has 50.000 clients, Verizon 25.000, Vodafone 15.000 and Orange 10.000. The total clients are 100.000.

       

      I'd like to select a vendor, i.e. AT&T, see that they have the 50% of the market and the three other vendors (grouped the three other Telecom) have the remaining 50%. I know how to do it manually, but I don't know if it can be programmed automatically like:

       

      Remaining ones: 100.000 - Current selection

      Percentage of the market: 100% - current selected Telco in percentage.

       

      The idea of doing it automatically is that maybe I could face a scenario where I need to change so often the Telecom. I mean, after clicking on AT&T and see the results, I would click on Vodafone and see the results with the three other Telecom grouped.

       

      Thanks!!