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

Accepted answers

All comments

VIGNESH.M

Hi,

You can achieve this through Line item subset.

https://help.anaplan.com/anapedia/Content/Modeling/Dimensions/Line_Item_Subsets.html?Highlight=line%20item%20subset

-Vignesh

DavidSmith

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

Quick Links

Can you help?

Unanswered questions

Cloud works on UX page
I am unable to see the cloudworks integration on the UX page. Can you advise what I am doing wrong
how to count how many times an action has run?
I want to create a line item which will increment by 1 every time an action is run manually. This action is an import which doesn't involve any file upload to anaplan. The module where I want this line item has users list & SKU list dimension. No time. So basically, I want to track how many users have selected an SKU and…
Missing Column Headers in Anaplan Export When Using API
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…