Skip to main content
Documentation
Documentation
Adaptive Planning
Last Updated: 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 call the attribute Total.
  2. Create 1 attribute value and call it
    Product Total
    .
  3. Apply
    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 Tota
l 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.