# Counting number by snack name

**URL:** <https://community.glideapps.com/t/counting-number-by-snack-name/36899>\
**Category:** Ask for Help\
**Created:** [January 9, 2022, 4:44pm UTC](https://community.glideapps.com/t/counting-number-by-snack-name/36899 "2022-01-09T16:44:41Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\
**Post date:** [January 9, 2022, 4:44pm UTC](https://community.glideapps.com/t/counting-number-by-snack-name/36899/1 "2022-01-09T16:44:41Z")

</div>

Hi

I’m having a order table which has some column like, order no,snack name, quantity etc.,

If my order is like below

Snack name. Quantity. Order no.

A. 2. 1001  
B. 4. 1002  
A. 4. 1003  
B. 3. 1004

Now I need total no of snacks order per snack name  
like below

A - total - 6(2+4)  
B - total - 7(3+4)

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [January 9, 2022, 5:16pm UTC](https://community.glideapps.com/t/counting-number-by-snack-name/36899/2 "2022-01-09T17:16:54Z")

</div>

You’ll need to do a Multiple Relation where the snack names match each other. Then rollup that relation and get the sum of each matching item.

---

<div class="post-metadata">

**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\
**Post date:** [January 9, 2022, 8:34pm UTC](https://community.glideapps.com/t/counting-number-by-snack-name/36899/3 "2022-01-09T20:34:34Z")

</div>

I got the total snack orders per snack name and also how many times it’s ordered for the whole orders.

But I also need to display the snack name count of today only.any idea?

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [January 9, 2022, 8:55pm UTC](https://community.glideapps.com/t/counting-number-by-snack-name/36899/4 "2022-01-09T20:55:11Z")

</div>

If ordered date is within today, show total, else show nothing. Rollup that column to get data for rows “today”.