Sorting/Grouping on two fields Question 1

[hallux]

Hello,
I need to group on two fields, and can't get it to work out.
For an example I will use an inventory list of fruit and bin numbers.

Bin Item Desc Quantity

A17 Apple Macintosh 2
A17 Apple Fuji 1
none Orange Valencia 4
none Orange California 9
none Orange California 4

What I need to do is to group together according to bin number and Item Desc.
So, I would like to see


Bin Item Desc (Sum or count) of Quantity

A17 Apple Macintosh 2
A17 Apple Fuji 1
none Orange Valencia 4
none Orange California 13

Instead I get this

Bin Item Desc (Sum or count) of Quantity

A17 Apple Macintosh 3
none Orange Valencia 17

Which then makes it appear as though there are 17 Valencia Oranges.

Any ideas?

 

[mbarron]

I'm assuming you have 2 groupings. One for the Bin Location and then one for the Item Description.

Move the GroupName #1 field ( in this case the Bin) into the GroupHeader#2 section. Then hide the GroupHeader#1 section.

It should now look as you have shown above. Mike
If you're not part of the solution, you're part of the precipitate.

 

[hallux]

Thanks. I appreciate the help. I've been trying all kinds of things, didn't know you could do that.
-Brent