Hierarhical categories

Hi,

We have an internal structure for categories with subcategories.

For example

- categories
-- fruits
--- summer
---- watermellon
---- mellon
---- grapes
---- ...
--- winter
---- apples
---- oranges
---- ...
-- vegetables
--- green
---- letuce
---- ...
--- red
---- radish
---- ...
etc

(edit: sorry if it doesn't show up like a tree but that was my intention)

The categories can be anything and at any level.
Each record (lets say product) belongs to one category or subcategory only. Parent categories are implied.
Is it possible to make this work with fastcube and measure for example sales per category (including subcategories) and make it expand like a tree structure to see subcategories?

For example at top level we could see totals for fruits and vegetables (including everything below them).

Thanks