# Minimum values from Summed Totals in Crystal Reports

I am working on a crystal report. It has the following fields: item, component, warehouse, and quantity on hand. Please see detail view below:

Item Components Warehouse QuantityOnHand AZ1 153-54 1 31.00 AZ1 153-54 2 28.00 AZ1 153-54 Total 153-54 59.00 AZ1 153-84 1 31.00 AZ1 153-84 2 27.00 AZ1 153-84 Total 153-84 58.00 AZ1 153D89 1 31.00 AZ1 153D89 2 26.00 AZ1 153D89 Total 153D89 57.00

After I hide the details, I will get the following view:

Item Components Warehouse QuantityOnHand AZ1 153-54 Total 153-54 59.00 AZ1 153-84 Total 153-84 58.00 AZ1 153D89 Total 153D89 57.00

I am trying to identity the Components that have the lowest QuantityOnHand for every item. When I use the MIN function in crystal, it does not work. In this example, I would like to only show AZ1 153D89 Total 153D89 57.00

Any help would be appreciated.

Thanks

AZ1 153-54 1 31.00
AZ1 153-54 2 28.00
AZ1 153-54 Total 153-54 59.00
AZ1 153-84 1 31.00
AZ1 153-84 2 27.00
AZ1 153-84 Total 153-84 58.00
AZ1 153D89 1 31.00
AZ1 153D89 2 26.00
AZ1 153D89 Total 153D89 57.00
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Professor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Group at level 1 by Item
Group at level 2 by Component
Create a sum at level 1 and level 2 of QuantityOnHand

Use
Report, Group Sort Expert
to sort Group Level 2 as a Bottom N sort with N = 1

Experts Exchange Solution brought to you by