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