BlueGravel
New Member
- Joined
- Nov 4, 2014
- Messages
- 2
I have data that sort of looks like this
1 or many items
-- > 0 or many children items
----> 0 or many children items
------> 0 or many children items
--------> 0 or many children items
In other words, the data is a hierarchical tree structure, where each brand has data needed. Some of these tree's have more 'generations' then others.
Someone wants reports where they can easily drill down into these items.
Note: Data is currently in Access DB, and VBA is used to generate Excel report (including pivot tables). That all basically works fine, but these are new request.
I'm not very familiar with pivot tables, but don't think they would work here.
Grouping in excel would be ugly.
Sunbust charts would have too much info I think (and I don't think they would like this).
What would you suggest the best way to represent this data in excel?
Think my backup plan might be to explore just leaving excel out of these reports and having a form in access do all the heavy lifting.
1 or many items
-- > 0 or many children items
----> 0 or many children items
------> 0 or many children items
--------> 0 or many children items
In other words, the data is a hierarchical tree structure, where each brand has data needed. Some of these tree's have more 'generations' then others.
Someone wants reports where they can easily drill down into these items.
Note: Data is currently in Access DB, and VBA is used to generate Excel report (including pivot tables). That all basically works fine, but these are new request.
I'm not very familiar with pivot tables, but don't think they would work here.
Grouping in excel would be ugly.
Sunbust charts would have too much info I think (and I don't think they would like this).
What would you suggest the best way to represent this data in excel?
Think my backup plan might be to explore just leaving excel out of these reports and having a form in access do all the heavy lifting.
