Sales, Targets, and Commission...

View previous topic View next topic Go down

Sales, Targets, and Commission...

Post  cschuessler on Tue Jun 26, 2012 9:50 am

I am currently doing some modeling to facilitate Retail Sales and Targets, ultimately paying commission on the sales achieved. The sales information comes from a transactional table, and is aggregated into a Fact table to have the total sales by Day, by store, by Employee.

The target information, in a seperate fact table, has the target value by Store, by Day. (note the targets are set at a store level, and not by employee)

I need to pay commission to any employees who have achieved sales in a store that has met its target for the month.

I am having difficulty in understanding how best to position the data in order to do this.

Any advise would be greatly appreciated. If you require clarification on what I am attempting, please let me know.

Thanks in advance.

cschuessler

Posts : 1
Join date : 2012-06-26

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum