W
Wayne Stearns
Hello all!
I'm currently building a large model for work that ultimately calculates P&L
line item variances between our 2 different financial reporting systems. As
the variances must be able to be viewed across 4 different hierarchy levels
(from a business unit down to a product line), I'd like to provide the user
drop down menus for selecting particular data at every level of the
hierarchy that is displayed as an output table depending on what the user is
trying to view. This would allow someone to view the variances at a
business unit level all the way down to a product line level. Does anyone
know the most efficient way to do this?
List 1: Business Unit the user wants to view (After making a selection I'd
like to have it set up so the data can be summarized in table format at this
point or the user gets another drop down list for drilling down further
based on their initial selection)
And so on...
Thanks
I'm currently building a large model for work that ultimately calculates P&L
line item variances between our 2 different financial reporting systems. As
the variances must be able to be viewed across 4 different hierarchy levels
(from a business unit down to a product line), I'd like to provide the user
drop down menus for selecting particular data at every level of the
hierarchy that is displayed as an output table depending on what the user is
trying to view. This would allow someone to view the variances at a
business unit level all the way down to a product line level. Does anyone
know the most efficient way to do this?
List 1: Business Unit the user wants to view (After making a selection I'd
like to have it set up so the data can be summarized in table format at this
point or the user gets another drop down list for drilling down further
based on their initial selection)
And so on...
Thanks