Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Extending Bex query for FTM and YTD values

Hi Experts,

I have a FI-GL custom query that displays all months of the year as Key Figs. The filter is on Year, Version. Want to add FTM (For-The-Mth) and YTD columns. If I select period as 002 in the variant the below result is to be displayed. see fig:

JanFebMarFTMYTD
150100400100250
2002525025225
2305030050280

We are getting the monthly figures and the year as part of the Version (A2012 or A2013 etc.) from the custom datasource. Fiscyear or FiscPER are not being used.

Thanks

mf

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question