Simple Sum question
This is a simple one but just having a hard time getting it to work.
I have multiple clients who purchase a variety of products per invoice. I need a Sum of the Product Type per Client. I've attached an image.
For example, I'd like to know Sum of Product 1 for Client 1. In this case the running total =5.
I realize I could do this in a report, but I need it as an equation (likely in a metric sheet) so I can add automations/notifications when a client might be reaching a threshold of Products purchased.
Help Article Resources
Check out the Formula Handbook template!