sagobogger
Technical User
Not quite sure how to title this one but here's a simple example.
Suppose I have a car dealership and my total month sales are:
I want a report by each salesperson that shows their individual sales and the % of the dealership total sales by vehicle type.
Not all salepersons will have sold all types of vehicle, and I can't figure out how to get the dealership numbers on the report for the vehicle types they didn't sell.
So Joe's page of the report should look like this:
Suppose I have a car dealership and my total month sales are:
Code:
4dr Sedans 100
2dr Sedans 80
Convertibles 20
PickUps 30
Vans 25
Not all salepersons will have sold all types of vehicle, and I can't figure out how to get the dealership numbers on the report for the vehicle types they didn't sell.
So Joe's page of the report should look like this:
Code:
Type Dealer Joe Sales % of Dealer Total
4dr Sedans 100 10 10%
2dr Sedans 80 8 10%
Convertibles 20 5 25%
PickUps 30 0 0%
Vans 25 0 0%