on 04-30-2018 1:48 PM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi James ,
Just to Start with.
Can you please Check Info Tab in RSRT what year it is picking for PYTD?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
59 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.