I'm pretty sure a Pivot Table would solve your dilema.

Use column headings above your data Fruit, Type, Amount, etc.

When setting the layout: ROW:Fruit,Type , DATA:Amount

Then you can select any combination of Fruits and Types to display.

Does that help?

--
Regards,
Ron