1 Reply Latest reply on Feb 11, 2016 2:07 PM by Burak Tansug

    Calculating % share of each product category in the total change of revenue

    Burak Tansug

      Hi,

      I have 10 product categories and their 2014 and 2015 revenue numbers.

      I want to calculate what's the percent share of each category in the total decline in revenue from 2014 to 2015.

       

      I have the calculated field for the year-to-year revenue change. In addition to the $ amount of this change, I need to add the % share of each category's decline in the total revenue decline.

       

      Please see attached twbx

      Appreciate any help you might be able to offer.

       

      Thanks

      Burak