Get Value of Top Level

Options
drushford
drushford Member, ALL USERS, Partner Posts: 4 Occasional Contributor
in Planning & Modeling

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?

Tagged:

Comments

  • drushford
    drushford Member, ALL USERS, Partner Posts: 4 Occasional Contributor
    Thank you!
  • vardhan_24
    vardhan_24 Member, ALL USERS Posts: 5 Occasional Contributor
    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
    nickstock Member, ALL USERS Posts: 1 New Contributor

    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)

Categories