Crosstable looks like this:

 

           Employee1      Employee2       Emplyee3
Day 1      sales/hour     sales/hour      sales/hour
Day 2      sales/hour     sales/hour      sales/hour
Day 3      sales/hour     sales/hour      sales/hour

I dont know how to do the sales/hour thing.

I know how to calculate the sales per day

I know how to calculate the worked hours per agent per day

But I do not know how to combine them and add them to the crosstab.

 

I'd be really helped if someone could provide a solution for this. Surely I'm not the only one in the world trying to show sales per hour per employee in a crosstab