# Glide Pages and Rollup for rows and columns

**URL:** <https://community.glideapps.com/t/glide-pages-and-rollup-for-rows-and-columns/56428>\
**Category:** Ask for Help\
**Created:** [January 6, 2023, 7:39pm UTC](https://community.glideapps.com/t/glide-pages-and-rollup-for-rows-and-columns/56428 "2023-01-06T19:39:31Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Wim\_De\_Coninck](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wim_de_coninck/32/28179_2.png) [@Wim\_De\_Coninck](https://community.glideapps.com/u/Wim_De_Coninck)\
**Post date:** [January 6, 2023, 7:39pm UTC](https://community.glideapps.com/t/glide-pages-and-rollup-for-rows-and-columns/56428/1 "2023-01-06T19:39:31Z")

</div>

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](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/5/c5764b2d39d108868f800c2331755f6873d06165.jpeg) .

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](https://community.glideapps.com/t/trash-your-excel-formulas/55788)) 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](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/6/56dff930a0b5e53718e7e6cbcb0e8de19cf7e5e4.png)

(year could be added in a filter)

Thanks a lot for helping !

Wim

PS. row and column-totals would be an extra 😉

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [January 6, 2023, 8:06pm UTC](https://community.glideapps.com/t/glide-pages-and-rollup-for-rows-and-columns/56428/2 "2023-01-06T20:06:37Z")

</div>

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:

> **[Loom - Mouse Highlight Overlay - 6 January 2023](https://www.loom.com/share/9b01045b307c4592b645c76c7b113aef)**

---

<div class="post-metadata">

**Author:** ![Wim\_De\_Coninck](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wim_de_coninck/32/28179_2.png) [@Wim\_De\_Coninck](https://community.glideapps.com/u/Wim_De_Coninck)\
**Post date:** [January 7, 2023, 7:11am UTC](https://community.glideapps.com/t/glide-pages-and-rollup-for-rows-and-columns/56428/3 "2023-01-07T07:11:25Z")

</div>

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?!)

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [January 7, 2023, 6:22pm UTC](https://community.glideapps.com/t/glide-pages-and-rollup-for-rows-and-columns/56428/4 "2023-01-07T18:22:22Z")

</div>

> [@Wim\_De\_Coninck](#):
>
> do you ever sleep?

Not the first time someone’s asked me that 😅

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