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

mikesuter

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.

mikesuter

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

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

@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.