# How to Sum sales orders of a specific customer

**URL:** <https://community.glideapps.com/t/how-to-sum-sales-orders-of-a-specific-customer/54163>\
**Category:** Ask for Help\
**Created:** [November 15, 2022, 12:28am UTC](https://community.glideapps.com/t/how-to-sum-sales-orders-of-a-specific-customer/54163 "2022-11-15T00:28:35Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jon\_Alsup](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jon_alsup/32/49100_2.png) [@Jon\_Alsup](https://community.glideapps.com/u/Jon_Alsup)\
**Post date:** [November 15, 2022, 12:28am UTC](https://community.glideapps.com/t/how-to-sum-sales-orders-of-a-specific-customer/54163/1 "2022-11-15T00:28:35Z")

</div>

I am trying to figure out how to sum the sales orders of specific customers.

I have everything tracking properly and can see all the sales orders by customers, but I can’t for the life of me figure out how to do a rollup or sum of just specific customer data.

I imagine i would probably need to create another table to do this. Any help would be great…

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [November 15, 2022, 12:35am UTC](https://community.glideapps.com/t/how-to-sum-sales-orders-of-a-specific-customer/54163/2 "2022-11-15T00:35:28Z")

</div>

do not create more tables, just filter the data… use customer row ID or email… create a relation or IF\_ELSE column to separate these orders from others, use rollup column to sum them

---

<div class="post-metadata">

**Author:** ![Jon\_Alsup](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jon_alsup/32/49100_2.png) [@Jon\_Alsup](https://community.glideapps.com/u/Jon_Alsup)\
**Post date:** [November 15, 2022, 12:44am UTC](https://community.glideapps.com/t/how-to-sum-sales-orders-of-a-specific-customer/54163/3 "2022-11-15T00:44:16Z")

</div>

Okay, so I create a relationship column - this then finds all orders related to that user. Then how do I get the sum of that column. Since that would be the Unique id (shown as many times as they have orderd)

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [November 15, 2022, 12:47am UTC](https://community.glideapps.com/t/how-to-sum-sales-orders-of-a-specific-customer/54163/4 "2022-11-15T00:47:58Z")

</div>

Create a Rollup column that uses that relation.

---

<div class="post-metadata">

**Author:** ![Jon\_Alsup](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jon_alsup/32/49100_2.png) [@Jon\_Alsup](https://community.glideapps.com/u/Jon_Alsup)\
**Post date:** [November 15, 2022, 12:52am UTC](https://community.glideapps.com/t/how-to-sum-sales-orders-of-a-specific-customer/54163/5 "2022-11-15T00:52:39Z")

</div>

Thank you both.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [November 16, 2022, 12:53am UTC](https://community.glideapps.com/t/how-to-sum-sales-orders-of-a-specific-customer/54163/6 "2022-11-16T00:53:16Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.