Hello,
This is the situation:
I have a number of charts/tables that are currently static and work off of the time frame of Current Fiscal YTD. I now need the tables and charts to either display the data based off of either LFY or FYTD based off of a selection field (radio, dropdown, etc...) within VC.
The trick is that I would like to still use only that one query, but perhaps modify it. I know that I would need to increase the filter to encompass LFY to present. But, I am curious to know what other steps I would need to take within BEx Designer as well as the steps needed within Visual Composer.
Lastly, I would like to point out that I have just started using SAP about a month ago, so I am quite the novice. Please don't assume that I know more than I really do (which is not much).
Thank you for your detailed responses.
~TJS