How to Sum sales orders of a specific customer

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…

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

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)

Create a Rollup column that uses that relation.

Thank you both.

1 Like

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