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
Bookmarks