Skip to Content
avatar image
Former Member

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:

Jan Feb Mar FTM YTD 150 100 400 100 250 200 25 250 25 225 230 50 300 50 280

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 08, 2015 at 05:39 PM

    Hi Farot,

    Can you take a screenshot of rowsxcollumns of your Query definition under Query Designer?

    This could enlight someone to figure out what is going on..

    Regards,
    Edward John

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks for the follow up John, we changed the datasource and managed to get the desired result.

      Farooq