Retrieving YTD value when timescale spans multiple years

SEllis

Hello,

 

I am having trouble with how to model for multiple time period aggregation combinations.  Using units as an example, I want the units for the individual time periods, quarters, and years, however I also require the QTD, YTD, and YTG (Year to go).  What is the best practice to incorporate this into a module?  I understand that this increases the cell count (and ostensibly the sparsity).

 

A few options that I am working through:

  - A way to have the above as a context list (pivot point) on a module which would facilitate different time aggregations in the same time period.  This presented the complication of telling the module function how to calculate based on this selection (not sure how to do that yet).

 

I have been able to work around this as a combination of list items, such as Units, Units QTD, Units YTD, etc.  This doesn't seem like an effective approach, wanting to know if there is an alternative option.