How can I produce a total, for example, the total amount for a month, using a button, etc?
You can use a Rollup column to create totals. If you want to Rollup filtered data, then you can also apply a Rollup column to an existing relation or query instead of an entire table.
When trying to Rollup a value for a specific month, it’s best to use a math column to convert any dates into an easy numeric value.
This in a math column will give you the year and month joined together.
Year(Date)*10^2 +Month(Date)
Then you can use that number to create relations.
3 Likes
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.