I'm doing my own head in here. Can anyone help please?! Its really complicated to explain and I can't attach the spreadie as its full of commercial data.
Basically I am trying to build a KPI performance tracker that will auto populate with the correct Target figure when two criteria are met and then I can work out the difference between the target and actual figures. Theres a load of different clients and each one has 8 different KPI's against them.
It needs to look at the client cell in the pivot filter and then at the Priority (1, 2, 3 etc) column in the pivot then refer back to an array to say 'right the client is Macdonalds' and the Priority for the job is P1 so therefore the target attendance SLA is 1 hour'
or 'the client is Smiths and the priority for the job is P4 so the target attendance SLA is 48 hours'
Any ideas? All help appreciated...
Bookmarks