Is there any way we can extract FX Rates in YTD format from FCC

Summary:

Hi All,

Is there any way we can extract FX rates in YTD format from FCC.

We are able to extract Periodic data but not YTD as expected.

we wanted to extract rates in YTD format as above

FCCS_YTD - Jan = Jan—> FCCS_Periodic—>Ending Rate

FCCS_YTD - Feb= Jan—> FCCS_Periodic—>Ending Rate + Feb →FCCS_Periodic—>Ending Rate

FCCS_YTD - Mar= Jan—> FCCS_Periodic—>Ending Rate + Feb →FCCS_Periodic—>Ending Rate + Mar →FCCS_Periodic—>Ending Rate

We try to create the stats accounts for rates cubes but unbale to create the member formula. is there any way that we can achieve this? Please advise