Calc Script for YTD
in Essbase
Summary: I am trying to create a separate dimension in Planning called "View" using a member formula to calculate MTD, QTD or YTD values based on the selection made in the "Period" and "Years" dimension.
Examples:
User selects
Period: Apr Year:FY24 View: YTD - The expected result should be a sum of data from Jan FY24-Apr FY24
Period: Apr Year:FY24 View: QTD - The expected result should be a sum of data from only Apr FY24
Period: May Year:FY24 View: QTD - The expected result should be a sum of data from Apr FY24-May FY24
Tagged:
0