need SUBTOTAL across Time

Highlighted
Previous Contributor

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?

3 REPLIES 3
Highlighted
Previous Contributor

RE: need SUBTOTAL across Time

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.
Highlighted
Community Boss

RE: need SUBTOTAL across Time

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, Chris
Highlighted
Previous Contributor

RE: need SUBTOTAL across Time

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.