Forum Discussion
Help - Query hasn't grouped properly
This happened because you included the 'AllocatedQuantity' in your group by. It looks like all of the other rows had a quantity of 800 so it grouped all of those together and grouped the one with 700 by itself.
To fix this, just go into the step where you grouped the columns and remove the 'Allocated Quantity' from the grouping!
This happened because you included the 'AllocatedQuantity' in your group by. It looks like all of the other rows had a quantity of 800 so it grouped all of those together and grouped the one with 700 by itself.
To fix this, just go into the step where you grouped the columns and remove the 'Allocated Quantity' from the grouping!
Syk thank you for the support on this. This worked as you probably expected.
Would you be able to explain why this was the problem. Im not sure i understand why this caused the above issue?
Thank you