2 Replies Latest reply on May 26, 2014 11:09 AM by egbaumier

    How to get calculation between 2 fields at 2 level sorted report?

    egbaumier

      At Report sorted by Month I have:

       

      Customer Order Amount

      Acme 100

      Drax 140

      Pix 160

      (Total when sorted by Month) = 400

       

      I need to represent customer share per month, such as:

       

      Customer Order Amount SHARE

      Acme 100 25%

      Drax 140 35%

      Pix 160 40%

      (Total when sorted by Month) = 400

       

      SHARE should be Total Amount Order from every Customer sorted by Month / Sum of All Order Amount from a lll Customers at the same Month.

       

      I tried several different ways from Calculation, Summary e Global Field without any success.

      Maybe this solution is simple but I couldn’t figure out.

      Is there any suggestions?

       

      Regards

       

      Edison

      FM13 Pro Advanced