Combine Information

[Steve-O (Steve Steder)]

Hello everyone,
I am looking for some guidance.
I would like to combine information
as I have in the picture.

Job # 243584 Produced 39 lots with a total of 74,617.14 #, 37.31 Tons .

I can do this in excel easily using a pivot table. I want to keep everything in Epicor.

I appreciate everyone suggestions.

Thank you.

[MLamkin (Marjorie Lamkin)]

It seems like that would be fairly simple, though I could be wrong
In the BAQ, you’d just join the tables, group by the job and in calculated fields do the Count and Sum operations: