Skip to Content
0

SAP Bex Query Designer Year to date

Apr 30 at 12:48 PM

54

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Nora Roch
May 02 at 10:38 AM
1

Hi James,

check out the Feature 'Current Member Variable'.

Cheers,

Nora

Share
10 |10000 characters needed characters left characters exceeded
Ashu Yadav Apr 30 at 06:35 PM
0

Hi James ,

Just to Start with.

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 01 at 02:00 PM
0

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?

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0
avatar image
Former Member May 01 at 02:00 PM
0

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?

Share
10 |10000 characters needed characters left characters exceeded