I recently queried a large dataset from Access. It is sales data for auto parts and is segmented into 3 category tiers. 1st is Department (e.g. Air Fresheners). 2nd is Category (e.g. Spray Air Fresheners). 3rd is Subcategory (e.g. Aerosol Spray Air).
I want to be able to sum sales based on Department, and then be able to expand into the 2nd and 3rd tiers by clicking a button. And, of course be able to go back to the 1st tier.
How can I tell Excel which 2nd tier items to associate with 1st tier and so on?
Pivot table possibly? I have never used one.
Bookmarks