SAP Bex Query Designer Year to date

[former_member576227]

Hi all

I am trying to build a report that shows 2018 vs 2017 year to date. Of course 2018 will show the 2018 YTD number, however I cannot get 2017 to show the YTD number. I don't want the user to select any year or month, when the query refreshes it should just pickup the correct dates.

I tried putting a structure in using Invoice Year and then selecting Current Year -1 but that does not work. Any Suggestions?

Thanks

James

[nora_roch]

Hi James,

check out the Feature 'Current Member Variable'.

Cheers,

Nora

[former_member576227]

Hi Ashu

Thanks for getting back to me. I am pretty new to the Bex Query designer, so when you say RSRT what are you referring to?

[former_member576227]

Hi Ashu

Thanks for getting back to me. I am pretty new to the Bex Query designer, so when you say RSRT what are you referring to?

[cornelia_lezoch]

RSRT is a transaction where queries can be executed withing the backend and more detailed info is available

[ashu33]

Hi James ,

Just to Start with.

Can you please Check Info Tab in RSRT what year it is picking for PYTD?