Get a total value on other line item

CarlosRod
CarlosRod
in Modeling

Hi,

 

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". 

 

CarlosRod_0-1652793317371.png

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

 

CarlosRod_1-1652793458743.png

 

 

Tagged:

Best Answer

  • M.Kierepka
    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.

Answers

Categories