- You want to have a list of months with a field of “month name”. Then for each tip you want to have a field “month name”. You want to autopopulate this field with the name of the month of the date of the tip. The simplest way to get that is to call an api that can calculate the month when given a date. Eg with make.com you can just create a webhook that responds with the month name when you pass it the date of the tip (or just the current month assuming you a recording the tip in the month it happens).
- Add a DDLB of the months.
- Then to display you want to show a list of months where “Months name” contains the DDLB value, with the elements “Month name” and “Total” where “total”=sum[tips] where tips(month) = “Month name”.
ufffffff, thank you!