Things I have tried
I prepared my September expenses under a folder and in different files for each day. Thus, there is information about my expenditures on each day of September. For example, on September 1, I had 3 different expenses. I fill them according to the template I prepared earlier in the “01 September” file. These include basic information such as where, with which payment method and how much. By the end of the month, there will be 30 different files in the “September” folder. I named these files as follows: 01 September 2022, 02 September 2022, … 30 September 2022. Finally, I opened another file called “Expenditures” in the same folder, different from these 30 files. I created a dataview table inside this file. My goal is to see all my expenses in a table.
What I’m trying to do
I was able to partially achieve this using the relevant codes. I can even see the totals for each day using the “sum” function. However, I would like to see the general total for September somewhere under the table. I couldn’t find a way to do this. In summary; How can I print the grand totals of numerical data kept in separate files in the same folder in another file.
TABLE
Spend as "Spend ($)",
Company,
Method as "Payment Method"
sum(Spend) as "Total Spend ($)"
FROM "September"
WHERE type = "sept_daily"
“sept_daily” is in the metatag of each file.