How to Sum sales orders of a specific customer

Ask for Help
1

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…

2

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

1 Like
3

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)

4

Create a Rollup column that uses that relation.

5

Thank you both.

1 Like
6

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