Hi how can I show multiple vaules in the same group row
(not sure if this is the right way to say it)
example
table( PalletNo, box weight, count)
Values
19,10,1
19,20,1
19,20,1
19,20,1
How do I querie this so that it will display
Pallet, boxes, sum(count)
19, 20x3 10x1, 4
Please try the following:
Open in new window