Formula to display values from the page selector in a column

Highlighted

Formula to display values from the page selector in a column

Hi, 

 

I need to be able to display the page selector value in a column. 

 

CommunityMember117741_1-1583853446679.png

The purpose of the module is to assign multiple positions to an order. If it had been the other way around (assign an order to position) I could have used an "assign" action, but, now he task is to do it this way. I need the order column to display the order code (same code in all the cells) for the order that is selected in the page selector.  So in this case all cells in the order column should display 10973030. 

 

Thanks for your help. 

 

Kind regards, 

 

Gabriel 

 

2 REPLIES 2
Highlighted
Community Boss

Re: Formula to display values from the page selector in a column

you can simply type the formula:

 

ITEM(name of your list)

 

make sure to format your line item as your list 

ps: it is also possible to remove the other dimension from this line item as the formula depends only on the order dimension


Nathan Rudman, Anaplan Model Builder
Highlighted
Super Contributor

Re: Formula to display values from the page selector in a column

Hi @CommunityMember117741 

 

You have already used order list in dimension so you can write item(order list name) as formula. it will show the order number same as on page.

Screenshot_132.png

 

Hope this helps!

Thanks

Akhtar