Remainder of the Year (YearTotal - YTD)
Anyone have any suggestions on how to calculate "Remainder of the Year"; logically this would be YearTotal-YTD
This is also attached to an existing Planning cube so a re-jigging the Period dimension isn't really an option.
Is there a way to tell a dynamic time series to use the Rdescendants rather than Ldescendants?
Custom function via mdx?
Any and all suggestions are much appreciated!