Get Value of Top Level

I have three lists: Product Lines L1, Product Category L2, Products L3. Total Products is the top level of Product Lines L1. I'm trying to calculate the product mix of each product in Products L3 as a percentage of Total Products. The module.line item that has the volume is Sales.Units Sold. But my question isn't about the mix calculation. I'm first concerned with just trying to get the Total Products value from the Sales module. I've tried a number of different formulas, but nothing seems to work. So how do I get the Units Sold value at the top level?

Accepted answers

VIGNESH.M

Hi,

Use Select Fucntion,

https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/SELECT.html?Highlight=select

Logic,

Unit Sold[select:Total Company]

~Vignesh

All comments

VIGNESH.M

Hi,

Use Select Fucntion,

https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/SELECT.html?Highlight=select

Logic,

Unit Sold[select:Total Company]

~Vignesh

drushford

Thank you!

vardhan_24

Hi

You can use the hierarchical capability of SELECT() function to roll up any hierarchical attribute and get the desired value. In this case, you can roll up the total items sold at the top level.

nickstock

Just to add to this, you may have to find where 'Total Company' sits on your Lists Hierarchy, so for me the formula was:

Unit Sold[SELECT: Country.Total Company]

Where 'Country' is the name of my list that contains 'Total Company' (see snapshot)

Capture_48546.JPG

ArunManickam

Kindly note, when you just refer a line item from a source module into a destination module, in such a way that the destination module does not have the source dimensions, it will automatically pick the top level for each of the source dimension. No need to specifically mention select - top level.

Thanks

Arun

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…