(some words in Dutch…)
I’m making (in Glide PAGES) my own expenses/revenues application, roughly based on the “Business Reporting”-template.
Input form to save data in my table “verrichtingen” is OK ; see first screenshot with some explication of the columns.
But now, I want to summarize all this info, if possible as a data grid, with a layout as in the second screenshot. I tried different calculated columns with relations and rollups (as seen in the Business Reporting"-template), but nothing works. I also read the sumif-explication from Robert Petito (🚮 Trash your Excel Formulas) but couldn’t find a way to put this in my GlidePage.
Has anyone any suggestion how to “group” by month AND by category.
(year could be added in a filter)
Thanks a lot for helping !
PS. row and column-totals would be an extra