Calculate Average by Group and total 1

[DeanReedy]

I have a report that deals with Products and cost.

I want to know the average(mean) of the product cost.

Grouped by
Salesmen
Product
Customer

I have the report all setup and grouped correctly, but I do not know how to average the cost field. I can total the field but how do you average?

thanks,
Dean

 

[nobull613]

Assuming the Product Cost is a numeric field, you should be able to drop the Product Cost field in the details, right-click on it, select Insert then Summary and one of the options will be Average. You can select which group to average the cost on and click OK. Once you have the summary in a group, you can copy it and paste it into the other group levels.

Hopefully that helps.

 

[DeanReedy]

nobull613,

That is exactly what I needed thank you very much!

Dean