Creating an aggregate report

Hi,

I am new to Zoho creator. I have developed a database but now on my dashboard want to create a table based on dates. Essentially, I want it to show me the totals by month. I have no idea how to do this - any help would be appreciated.

Thanks

Andrew