this is working, but a piece is missing. I would like to have also a generic row for commission: in the example below Crowford got 40% for all territory not equal to "A" since this latter value is specified.
How i can do this? So there should be kind of hierarchy: if the territory is available, use the % by territory, if not use the generic one.
Hope i explained myself.
SalesRep, Territory, Percentage, DataRangeStart, DataRangeEnd Crowford, A, 10%, 01/01/2019, 31/12/2019
This would be a second logical operation. After you've populated the respective percentages, you want to check if they exist and if not - apply some default value (I presume you have such value). Here is how you can achieve this with the code I sent. Green is new code.
//Exammple for Territory default Percengates in a heirarchy TerritoryPercengate: MAPPING LOAD * INLINE [ Territory, DefaultPercentage A, 10% B, 20% C, 30% D, 50% E, 60% ];
Did Stoyan's last post get you what you needed? If so, do not forget to come back to your post and use the Accept as Solution button the post(s) that helped you get things working to give credit to Stoyan for the help and to confirm to others the solution worked in this use case. If you are still working on things, leave an update on where things stand.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.