Get a total value on other line item

Question

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

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

M.Kierepka · Accepted 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.