For example, use lists to group similar products, employees in a department, or geographic regions.
You can also format line items as lists. For example, if a line item is formatted as the Regions list, its list items are available in the cell for the user to select from.
List items in lists are different to line items in a model. List items:
- Can only be referenced by a formula. Line items can be referenced by a formula, and can contain a formula.
- Can be used in any module. Line items belong to only one module.
Create and manage your lists in General Lists in the model settings bar. You can also search for lists in your model, reorder lists, and export lists.
Refer to the table below for a description of each column in General Lists
.Column name | Description |
Top Level | Assign a top level item to a list. A top level item represents the highest level in a hierarchy, and summarizes the data in your list. |
Parent Hierarchy | Assign a parent list to create list hierarchies in your model. |
Selective Access | Enable Selective Access for a list. Selective Access restricts access to lists and list items on a user-by-user basis. |
Production Data | Mark a list as a production list for Application Lifecycle Management (ALM). |
Managed By | Not available. |
Has Workflow | This is a legacy feature. |
Properties | Shows any list properties associated with a list. |
Subsets | Shows any list subsets associated with a list. |
Numbered | Mark a list as a numbered list. |
Display name property | Set the list property for display names. |
Is Organization | Mark the Organization list, a default list in Anaplan. |
Category | Set a category that summarizes the information in the list. Categories exist by default. |
Data Tags | Shows any data tags associated with a list. |
Item Count | Shows the number of list items in a list. |
Notes | Shows any notes associated with a list. |
Referenced in Applies To | Shows any modules and line items that use the list as a dimension. |
Referenced as Format | Shows any line items and list properties that use the list in line item format. |
Referenced in Formula | Shows any modules and line items that use the list in a formula. |
Next item index | Shows the index number for the next new list item in the list. Learn more in Reset the list index. |
Use Top Level as Default Page | Mark the list's top level item as a default page selector in the User Experience. Learn more in Configure lists. |
When you create a list, you can configure its settings and properties in Tree View, Grid View, Properties, Subsets, and Configure.
You can also copy list item data to other list items in the same list. For example, you could transfer a product's price and net profit to another product in the Products list.