New Contributor

Values from multiple line items into one line item split by a dimension

Not sure if this is possible. 

I have multiple line spread across multiple modules.   

I want to be able to bring all the values into one line item in a seperate module which it split by a dimension reprenting each of the unique line items.   

So I have:

Module 1 with Line Item A

Module 2 with Line Item B

 

I want Module 3 with Line Item C that has a dimension that consists of A and B

 

 

2 REPLIES 2
Certified Master Anaplanner

Re: Values from multiple line items into one line item split by a dimension

Community Boss

Re: Values from multiple line items into one line item split by a dimension

The above (Line Item Subsets) is definitely the most efficient, but it will only work for numeric values

You can use versions as per the previous post and use Version Formulae to pick up the relevant line item

You will set up a line item subset in the target model 

See here for more details

https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Add_Version_Formula.htm

Good luck 

David