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

Great, that was really needed.

Thanks for sharing easy explanation with screenshots! 

Contributors
Latest Articles
How to Reorder a List
Retail Knowledge Base
09-28-2020
SUM and LOOKUP for Retail
Retail Knowledge Base
07-31-2020