2 Replies Latest reply on Nov 24, 2016 8:46 PM by Deborupa Banerjee

    Profit/Total Sales for each Category

    Deborupa Banerjee

      Capture.JPG

      Hi All,

      Again I'm posting one question regarding calculations. This time the requirement is easy but I.m not sure why I am not able to achieve this.

      Follow the screenshot. Now I want the calculation like the profit of each sub-category should get divided by the total sales of that Category.

      I have done this for your ease on Superstore Dataset. Please help ASAP.

       

       

      Deborupa