2 Replies Latest reply on Jun 15, 2018 6:24 AM by Mavis Liu

    Need to divide a number of aggregated values by one single aggregated value

    dane tahbaz

      Screen Shot 2018-06-14 at 2.46.32 PM.png

       

      What I am trying to accomplish is a market share calculation for each territory. The issue I'm running into lies in the fact that WW is a field that is treated the same as thew other countries but is not a summation of the countries above it. Basically, I'm trying to get a calc that divides each country by WW field for each product_name. Any thoughts?