cancel
Showing results for 
Search instead for 
Did you mean: 

Extending Bex query for FTM and YTD values

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member186696
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

Farooq