I am hoping this is an easy question to answer. I have a report in which a user enters the start date and an end date. When the report is run all the dates appear in a table with a series of values along side of the dates (along with the name of the days, Monday, Tuesday etc.). I want to work out the average of these days, however I dont want all the days to appear. I just want one line which would say the average for Monday is XX, the average for Tuesday is XX etc etc. Any ideas on how I could do this?
thanks in advance
subfuze (BOB member since 2015-11-26)
