Skip to main content
Documentatie
Documentatie
Adaptive Planning
Laatst bijgewerkt: 2023-06-23
FAQ: Can I reference the total of a list dimension?

FAQ: Can I reference the total of a list dimension?

You can reference the total of a list dimension by referring to an applied attribute value. Example: You want to reference the total for the Product dimension.
  1. In
    Modeling
    , create an attribute for the Product dimension and name the attribute
    Total
    .
  2. Create 1 attribute value and name it
    Product Total
    .
  3. Apply the
    Product Total
     attribute value to all the Product dimension values.
  4. When you want the total, use this modifier in the formula:
    Acct.Revenue[Total=ProductTotal]
    .
This formula returns revenue data that has the
Product Total
 attribute. Because
Product Total
 tags all Product dimension values, the formula pulls all Revenue data tagged with any of the Product dimension values. The calculated value provides the total revenue of all products.