1 Reply Latest reply on Nov 30, 2017 6:07 PM by Zhouyi Zhang

    Market share calculation

    Colin Clark

      Need a refresher on this. Say I have revenue for three firms over time. I want to show a trend of their market share of revenue over time. If I eliminate one of the firms from a filter view, I want still want the market share to remain unchanged (i.e. can't use % of Total calc). What is the calculated field for this. Thanks

         

      Revenue Trends
      JanFebMar
      Firm 110020050
      Firm 2100100150
      Firm 3150150150
      Total350450350
      Market Share
      JanFebMar
      Firm 128.6%44.4%14.3%
      Firm 228.6%22.2%42.9%
      Firm 342.9%33.3%42.9%