Get a total value on other line item



Can you help me with the next item. I need get the total value of the line item "%" and put in the line item "Pond". 



in the line item "Pond" is using a LOOKUP but a cant see any value.





Best Answer

  • M.Kierepka
    Answer ✓
    Hi @CarlosRod,
    If you only need total value of your hierarchy (I assume your dimensions is called "Goe"), then you can do it by either:
    1. Changing formula to just reference "%", end then removing your Geo dimensions from "Applies To" (Anaplan will automatically pick up total sum).
    2. You can use formula "%[SELECT:Geo.All Regions]".
    FYI, I prefer 1st solution, as it takes less space.