12 Replies Latest reply on Sep 3, 2017 7:01 AM by Zhouyi Zhang

    % of Total Calculation

    Colin Clark

      How do I create a calculated field to calculate the "exchange % of total volume" based on example below. I don't want to use the quick table "percentage of total" calc.

       

      For example, in Jan, Exchange 1 % of total would be 27.7% [5/(5+6+7)].

       

      Exchange Volume Over Time

      Venue (Dimension)JanFebMar
      Exchange 1555
      Exchange 2666
      Exchange 3777

       

      Thank you, Colin