kindly check with the attached excel data set and i need to solve two questions
1.actual vs target sales-region/city/outlet/executive/product wise like drill down
2.how much incentive each exective get--
pls give some suggestions how to do this
i am already tried to create a hierarchy then put sales but how to do target vs achieved?
In your Data, You have only Target but not achieved.
First bring your Target in Data Sheet of excel from rest of the sheet using Vlookup and then you need to bring data of what they have achieved by region, sales person etc.