5 Replies Latest reply: Oct 7, 2011 6:37 PM by Rob Wunderlich RSS

    Calculating percentage share of total value

      Hello experts,

          I'm working on app where I'm suppose to display a table 3 columns

      promotion category, number of sales for category and percentage of sales for each category (This will add to 100% for all categories.).

      There could be sales that does not belong to any of the promotion categories. There are additional filters to fileter on year, month, region etc.

       

      I was not able to write formula to calculate percentage of sales for each category. Please advice me on this.

       

       

      Thanks,

      krishna