krishnabsharma
New Member
As a Sr. Manager, want to create a report with 3 main filter criteria’s as – Client Group, Project Name and Delivery Manager.
Whenever any manager selects values from these dropdowns, tabular report should get generated in report sheet from the BASEDATA
Available data -
· Basedata for all projects which will get refreshed through sql extract (this is there with me, because of security constraint uploading sample data-points here)
Requirement –
1. Table should be populated based on the combination of Client Group,Project Name and Delivery Manager selected values, E.g. –
· There could be one-to-many mapping between Delivery Managers and Client Groups, e.g. As you see in attached MASTER sheet,
Whenever any manager selects values from these dropdowns, tabular report should get generated in report sheet from the BASEDATA
Available data -
· Basedata for all projects which will get refreshed through sql extract (this is there with me, because of security constraint uploading sample data-points here)
Requirement –
1. Table should be populated based on the combination of Client Group,Project Name and Delivery Manager selected values, E.g. –
- If someone selects, ClientGroup1 from dropdown then respective Projects and Delivery Managers should appear in other relevant dropdowns
- If someone selects, DeliveryManager1 then respective Projects and Client Groups should appear in other relevant dropdowns
- None of the value should be blank
· There could be one-to-many mapping between Delivery Managers and Client Groups, e.g. As you see in attached MASTER sheet,
- ClientGroup1 is mapped to DeliveryManager1 and DeliveryManager3
- DeliveryManager1 is mapped to ClientGroup1, ClientGroup2 and ClientGroup3