6 Replies Latest reply on May 30, 2017 5:23 AM by Khalid Baker

    How can I calculate % of total sales based on Category? (Juice 30%, Energy 70% etc.)

    Khalid Baker

      Hey Everyone;

       

      Attached is the file.

       

      I would like to calculate a percentage of total sales per category. For Example, at the continent level, it shows Juice 30% and Energy 70%, but I would like to have at regional level than at country level potentially. For example, MENA would be 80% Energy & 20% Juice, but at the continent level it is 70% Energy and 30% Juice.

       

      Kindly help me with this calculation.

       

      Kind Regards;

      Khalid Baker