Hi,
I am having a module having a list dimension and weekly time scale. I want to cumulate the values of a line item w.r.t list items without cumulating it w.r.t time. Is there any way to do so ?
Try this,
We have the option to cumulate the value based on the list.
Formula = CUMULATE(VALUE, FALSE, 'Country')
Check this link,
https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/CUMULATE.html
@RahulSahoo
Both the ways will work that @VIGNESH.M and @nathan_rudman has suggested. However one thing with cumulate function is that if used against a named list it will follow the original display order and not the reordered list(if that happens later)
Thanks,
Misbah
Hello All, Is possible to Data label colours based on Legend? By default the Axis in ANPALAN steps up by 2.5K, how to manually adjust? Data labels for all legends is not displayed, possibly due to size, how to move the labels TIA
Hi, I was hoping to get some help with this situation, where I am trying to take a list to list mapping on the left and get an output similar to the right, but the main idea is i want to be able to make the selected item (format: list), the dimension of a target module and reverse map the original source list as a list…
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
