Line Item Format: List - Able to select any member if list hierarchy?

Options
mikesuter
mikesuter Member, ALL USERS, GroupMember, Certified Model Builder Posts: 4 Occasional Contributor
in Planning & Modeling

I am using a composite List hierarchy:

L1 List (Parents)
>L2 List (Parents)
>>L3 List (Children only)

 

In a module line item, I format a line item to Type = List, and List = L3 List

When I choose the pick box for that line item in the module, I can choose any member of L3 List.  The members of L1 List and L2 List appear in the pick box but are grayed out.

 

Question:  Is there a way to format a line item in a module such that I can pick all levels of the hierarchy (in this case be able to pick any member of L1 List, L2 List, of L3 List?

 

Thank you for your time and consideration.

Tagged:

Comments

  • mikesuter
    mikesuter Member, ALL USERS, GroupMember, Certified Model Builder Posts: 4 Occasional Contributor

    Thank you for your response.

     

    I am using line items (list format) to allow the users to create custom drivers in a budgeting/forecasting model.  For example, if my chart of accounts has three key dimensions:

    Account

    Department

    Analysis

    I can have the users choose members in line items (list format) for each dimension, and then refer to those items in a LOOKUP formula to return the driver value.

     

    In this case, the user may want to pick intersections at various levels of the hierarchy.

     

    I can work around the issue, it would just be a lot more fun and eloquent if I could select any member of the hierarchy in one place.

     

    Thanks again.

     

    Mike

  • mikesuter
    mikesuter Member, ALL USERS, GroupMember, Certified Model Builder Posts: 4 Occasional Contributor
     
     
     
     
     
     
     
     


     
     
     
     
     
     
     
     
    @ChrisAHeathcote

    Thank you for your response.
     
     
      My purpose is to inform downstream calculations.  I will use a workaround, similar to what you suggest
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     in your last pa
     
     
     
     
     
    ragraph.
     
     
     
     
     
     
     

Categories