tompatrick.ting
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
Community Boss

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

这是典型的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 REPLIES3
nathan_rudman
Community Boss

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

这是典型的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
tompatrick.ting
Contributor

@nathan_rudmanhi,

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

Thank you,

Tom

nathan_rudman
Community Boss

here it is

Nathan Rudman, Anaplan Model Builder