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.
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.0
I use the select and its working.0