+ Start a Discussion
SeaTecSeaTec 

Order Sales Price AVG report

I am trying to create a matrix report that will calculate a reps average sale per month for the last 365 days.  

There is one limiting factor i need to build in and this is their Start date as recorded in their user record.

I dont quite know how to tell the report not to include any numbers that are prior to their hire date. (we have some figures there due to move records around)

 

I am using the Avg and total column for order sale price  to achieve the end result. 

Any ideas are welcome.

 

Thank you