3 Replies Latest reply on Aug 1, 2014 6:45 AM by 966854

    Report requirement

    966854

      Hi Experts,

      We have 3 columns Division, Users , Diff category of Product  delivered

      In the 4th column I have to calculate Avg of all different products delivered.

      Different Cases I have :

      If it had 4 different category products it as to do sum of all the 4 and divided by 4

      If it had 3 different category products it as to do sum of all the 3 and divided by 3

      If it had 1 different category products it as to do sum of all the 1 and divided by 1

      How we have to calculate Avg and we are using Pivot table view

      Please find the below sample format

          

      DivisionUserDiff Category of product DeliveredAvg
      AX1010
      A 5
      A 10
      A 15
      AY1510
      A 5
      A 10
      AZ510
      A 15
      AW55

      Thanks in Advance