Show Total Revenue Based On Month

In my database, I have data type called “Sales” which has two fields - “Revenue”, and “Date”. The “Revenue” field holds individual data of the revenue created per sale. There are multiple sales throughout each month. I would like to create a page where the user can see the total Revenue that they have generated per month. I would like all 12 months to display on the page.

If possible i would also like to have a drop-down where the user can select the year that they’d like to see and then the list shows the total revenue for every month that occurred in that year.

Im assuming that this is done with a repeating group but I’m not sure how to group things by month or how to create the year filter system. I’d greatly appreciate any suggestions or help!

search about group by: this will solve your problem .