Fill line item with first list member

tompatrickting
Contributor

Fill line item with first list member

Hi ,

 

Is there a way I can fill up my line item with the first list member in the module ?

tompatrickting_0-1617694687872.png

Thanks in advance for helping.

 

Regards,

Tom

 

1 ACCEPTED SOLUTION

Accepted Solutions
nathan_rudman
Master Anaplanner/Community Boss

Re: Fill line item with first list member

the best way is to dynamically find the "lowest" rank and extract that. here's how.

It's the classic play with dimension top level and summary type of a line item. Set the rank summary to min, compare the rank against the min, if equel then it is the first. Set that LI summary to first non blank and extract the top level of this line item

 

 

nathan_rudman_0-1617695140866.png

 

nathan_rudman_1-1617695158253.png

 


Nathan Rudman, Anaplan Model Builder

View solution in original post

3 REPLIES 3
nathan_rudman
Master Anaplanner/Community Boss

Re: Fill line item with first list member

the best way is to dynamically find the "lowest" rank and extract that. here's how.

It's the classic play with dimension top level and summary type of a line item. Set the rank summary to min, compare the rank against the min, if equel then it is the first. Set that LI summary to first non blank and extract the top level of this line item

 

 

nathan_rudman_0-1617695140866.png

 

nathan_rudman_1-1617695158253.png

 


Nathan Rudman, Anaplan Model Builder

View solution in original post

tompatrickting
Contributor

Re: Fill line item with first list member

@nathan_rudman hi,

 

Please re-share the process. The how-to was cut in the comment.

 

Thank you,

Tom

nathan_rudman
Master Anaplanner/Community Boss

Re: Fill line item with first list member

here it is

Nathan Rudman, Anaplan Model Builder