I have a template where I have 9 Towers and in that i have different Queues and i want to pull the data from the 6 Work Sheets to the template (Working File).
In the Working File WS (E2) Cell I have a Validation list (P1, P2, P3, P4, P5, PNone) and Validation List (01-May-14, 02-May-14)
My Requirement is When i select P1 from the drop down (E11), the data should be pulled from the Pivot WS (A5) and when i select the date from the drop down (D11) the data should be pulled from the Pivot WS (Open Date) for the each group in the tower.
Please Note that based on the Date selected from the Drop down the P1, P2, P3.....PNone numbers should reflect, When i change the date the P1, P2, P3 drop down list should display the count for that day (Open Date in Pivot WS)
Other Requirement is, Achievement % (Formula is already provided by NBVC, just want to update it -- Please find below)
Requirement is Achievement % is L13/50% of S5 [L13 Divided by 50% of S5 (For P1, Tower 1, L13 to L22, S5 ........... till Tower 9)
(For P2, Tower 1, L13 to L22, T5 | ........... till Tower 9)
Same for all the priority.
[This data will be updated daily]
MTD --> MTD is the % Achievement from Overall Total P1 Incidents/50% of the S5 for each tower.
Same for P2, P3, P4 and the towers subsequently
Please help me in finding out the formula for this kind of requirement. Or I have also included the sample data, please suggest a formula which will best suit my requirement as per the Excel Report template.
Sample file attached.