Glide Pages and Rollup for rows and columns

1

Hi,

(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.

Afbeelding1
Afbeelding11569×801 117 KB
.

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.

Afbeelding2
Afbeelding21588×384 12.5 KB

(year could be added in a filter)

Thanks a lot for helping !

Wim

PS. row and column-totals would be an extra :wink:

2

This is a common scenario facing many Glide users — summing based on a Day, Week, Month, Quarter, etc.

In Glide, it involves a bit of trickery. See below:

3 Likes
3

Woow.
Very good video as an excellent tutorial. I now understand the logic !

(do you ever sleep? you made this video 1h (one!) after my question?! Huh?!)

4

Not the first time someone’s asked me that :sweat_smile:

My wife would tell you “no, no he doesn’t.”

1 Like