5 Replies Latest reply on Nov 20, 2018 7:24 AM by Anthony Griffiths

    Calculating Variance of Previous Quarter

    Anthony Griffiths

      Hi all,

       

      With the attached workbook, I'm a bit stuck on working out the previous quarter's average score for each Partner and Subcontractor.

       

      On Sheet6, if i use the lookup function, it can work if I only use the Quarter dimension but if I want to show a table with Quarter, Partner, Subcontractor I'm  not sure how to calculate the previous quarter's value for that particular Partner/Subcontractor as the lookup function can't determine which row to look at

       

      Hope this makes sense

       

      Any help would be greatly appreciated