How do I add in day total in view

[Cpreston]

HI

I am creating a view which shows the total for a group per day, so for todays date I have 10 entry's.
What I want is just a Total for the day, I cannot work our how to do this in my view, or add script to the sql code.

Attached is a screen shot of my view, any ideas please anyone

Thanks

 

[Cpreston]

Sorry all sorted it and for information I just added in the Group BY and did a sum on total volume, which added the code in

GROUP BY DateRequired, [Total Volume]

Thanks