Suming Invoice Amount with Specific Criteria
I have a table with data that looks like the sample data below. I would like to be able to sum the total invoice amount on a per job # level and be able to attribute it to the Firm designated as the "Original" for that job #.
As an example the Sum of invoices for job #1 would be 200 and it would be attributed to "Test Firm 1"
How can I do that in beastmode or is it something I need to do in a dataflow?