Skip to Content
avatar image
Former Member

SAP Bex Query Designer Year to date

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • May 02 at 10:38 AM

    Hi James,

    check out the Feature 'Current Member Variable'.

    Cheers,

    Nora

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 30 at 06:35 PM

    Hi James ,

    Just to Start with.

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

    Add comment
    10|10000 characters needed characters exceeded

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

    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?

    Add comment
    10|10000 characters needed characters exceeded

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

    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?

    Add comment
    10|10000 characters needed characters exceeded