Link to home
Start Free TrialLog in
Avatar of SteveL13
SteveL13Flag for United States of America

asked on

Trying to develop a report that sums sales by salesperson year by year

I am trying to figure out how to develop a report that looks like the attached.  I want it to always present the sum totals for each rep for the current year and one year back and two hears back.  The data all comes from one table.  The sales figures come from a field named "Purchase Price" and the dates come from a field named "Closing Date".

I don't even know where to begin.  Any help much appreciated.

User generated image
SOLUTION
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial