# Conditional Rollup on Big Tables

**URL:** <https://community.glideapps.com/t/conditional-rollup-on-big-tables/69766>\
**Category:** Ask for Help\
**Created:** [January 19, 2024, 11:07pm UTC](https://community.glideapps.com/t/conditional-rollup-on-big-tables/69766 "2024-01-19T23:07:57Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![AidanVrobel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aidanvrobel/32/69575_2.png) [@AidanVrobel](https://community.glideapps.com/u/AidanVrobel)\
**Post date:** [January 19, 2024, 11:07pm UTC](https://community.glideapps.com/t/conditional-rollup-on-big-tables/69766/1 "2024-01-19T23:07:57Z")

</div>

Hey guys,

I’m pulling data from another source via API and need to use Glide Big Tables for this application.

I am trying to figure out a way to create a conditional rollup based on date (week, month, cumulative).

I tried @Darren_Murphy’s year-month filtering solution, however, I realized that you can’t rollup computed fields in big tables.

If it helps, here is what the table looks like

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/8/d8238b719063f16b4ce89ab63e68b959d2091b04.png)

I have no problems rolling up the cumulative data, but I can’t figure out how to rollup only this week’s data or this month’s data with Big Table restrictions.

Any ideas?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [January 20, 2024, 12:42am UTC](https://community.glideapps.com/t/conditional-rollup-on-big-tables/69766/2 "2024-01-20T00:42:57Z")

</div>

What exact columns are you trying to rollup?

---

<div class="post-metadata">

**Author:** ![AidanVrobel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aidanvrobel/32/69575_2.png) [@AidanVrobel](https://community.glideapps.com/u/AidanVrobel)\
**Post date:** [January 20, 2024, 4:45pm UTC](https://community.glideapps.com/t/conditional-rollup-on-big-tables/69766/3 "2024-01-20T16:45:37Z")

</div>

Emails sent per month, emails sent per week, emails replied this month, emails replied this week, reply rate this month, reply rate this week, etc.

---

<div class="post-metadata">

**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\
**Post date:** [January 20, 2024, 9:27pm UTC](https://community.glideapps.com/t/conditional-rollup-on-big-tables/69766/4 "2024-01-20T21:27:37Z")

</div>

We’re working on enabling rollups of computed columns for Big Tables now.

---

<div class="post-metadata">

**Author:** ![AidanVrobel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aidanvrobel/32/69575_2.png) [@AidanVrobel](https://community.glideapps.com/u/AidanVrobel)\
**Post date:** [January 20, 2024, 11:34pm UTC](https://community.glideapps.com/t/conditional-rollup-on-big-tables/69766/5 "2024-01-20T23:34:51Z")

</div>

If it helps anyone I figured out a solution.

All of this data is being pulled via API so instead of calculating week end date/month end date in Glide, I am calculating these in my automation in N8N.

Then in the main table I am rolling up to (which is a regular Glide Table), I calculate week end date and month end date.

Then I do two queries, one for this month’s campaigns one for this week’s campaigns with the filter Week/Month End Date is on or after Week/Month End Date.

I can then do the rollup from the query, which acts as a conditional rollup.

Not sure if that made sense lol but the only solution I could figure out to get this to work.