Hello -
Let's say that I have three records in a form with two fields (Product, Order QTY):
Product A, 12
Product A, 37
Product A, 19
In a View, what I want to do is produce an output that looks like this:
Product A, 68
I don't want it to look like this:
Product A, 12
Product A, 37
Product A, 19
Product A, 68
Instead, I just want it to look like this:
Product A, 68
Just one row and ORDER QTY summed together, grouped by Product.
Is there a way to do this in a view? I've struggled with this... I can't seem to make it happen very easily.
R