Average

[timISST]

I have a report that looks similiar to this

customer
date field1 field 2 field 3

it will have new dates with the fields reoccuring what I need to be able to do is have an average showing at the bottom of each field. I was thinking i need to do a group by date but wasnt sure any suggestions?

 

[IanWaterman]

No point in grouping by date as you only have 1 recordset per date

Group by customer and add a simple average summary to Customer group footer

Ian