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