I have several machines that sometimes makes the same product.
Example:
m1: 100 apples
m2 : 50 oranges
m3: 200 apples
m4: 10 apples
m5: 140 pineapples
Is there a way to consolidate all the unique products into:
310 apples
50 oranges
140 pineapples
The grouping report does this but it is not what I need… I have to continue working with the consolidated data to assign cost and make the inventory entry.
Can you send support@ragic.com an email with the sheet link and elaborate more of this use case,
we need more information to give you appropriate advices.
Thanks for the responses. Both the Grouping Report and the Pivot Report will consolidate (group) them. However what I need is not a report. The problem is that I need the information (in this case the group totals) within the sheet, for further calculations.
In Excel i use the pivot table to group them and then apply a price. Then total these prices daily.
By the way this is not a deal breaker for me. What I have to do is apply the price individually to every entry. Then the use the Grouping Report.