How to Reorder a List

Retail Anaplanners!

New functionality came out today 9/26/2020 that makes ordering lists much easier.

Release Notes: https://community.anaplan.com/t5/Releases/What-s-New-September-26-2020/ba-p/85429

Documentation: https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Actions/Order-list.html

 

A game changer for many use cases. I will show you an example plus a way to reorder a list subset. I'm sure many of you will have a more creative way to order the list subset so please share!

First you have to create a module that uses the list, and only the list, that  you want to reorder. Add a line item that contains the order you wat - can be text or general number. 

ReorderList01.png

Create a Order List Action that uses that line item for that list. You cannot select a list subset. It must be a module that uses the complete list.

 

ReorderList02.png

Run the action. Success!

ReorderList03.png

For List Subsets I created a module that uses the list subset and added a Boolean line item set to TRUE.

In the module that uses the complete list I lookup the Boolean from the module using the subset list, as shown.

 

ReorderList04.png

Blueprint:

 

ReorderList05.png

 

Create the Action using the Final Order to Use Line Item

 

ReorderList06.png

The module using the list subset is now reordered.

 

ReorderList07.png

Comments

Categories