need SUBTOTAL across Time
In several cases I need to use a subtotal for 5 quarters in calculations. I have been using the All Periods total for most and it works some of the time. However, often I don't want values included from previous years. Ideally there would be a function like SUBTOTAL in Excel where the total would only be for the columns (time periods) that are shown in the view. I have not been able to find anything like this in the Anaplan community. Is there something that would approximate this? Or can we get it on the list of needed enhancements?
Tagged:
1
Best Answer
-
Hi Brent,
There was a new functionality that was released in 2015 called TIMESUM. I think this would answer your questions.
https://community.anaplan.com/anapedia/calculation-functions/timesum Here is some more information about TIMESUM.
You can also use Time Period formatting for line items.
You can check out the Whats new section of anapedia
Or you can download the Whats new App or the latest Formulas and Functions apps.
These will help you incorrorate any new updates.
Let me know if you have any questions.
Thanks,
Chris1
Answers
-
Good idea, maybe calculated in the view or dashboard on the fly would be sufficient (not building into the module)
And while you are there, possibly allow for other functions (divide, subtract etc) to be included. Could do variances etc, without impacting the base module. Would not aonly assist time, but also versions and other lists.0 -
Chris, this function is good, and useful - I will use it when calculating seasonality across 5 quarters. However it is awkward for the primary use case I have in mind. My preference would be to have it as another option in the time dimension (like YTD and YTG). I want to have multiple line items all summed over the given 5 quarters - to have an additional line item for each one would be cumbersome and confusing to the end user.0