1 Reply Latest reply on Oct 13, 2018 8:21 AM by Praveen Kumar

    How to show weighted avg for sitename, clientname and program?

    Praveen Kumar

      Hi All,

       

      I want to show weighted avg for Sitename, clientname, Programname w.r.t AvgHC and Metric target as attached file. In excel i have calculated based on Programname and the same roll upto SiteName and clientName.

       

      For Hyderabad=Sum of weighted avg = 1904 and for client AT&T = Sum of weighted avg = 1219.

       

      Please find the attached excel file and do the needful.

       

      Please let me know, if you any questions

       

      Thanks,

       

      Regards,

      Praveen