Hi,
In a SAP Analytics Cloud story, I have two dimensions in the rows of a table and one date dimension as column. The measure amounts are displayed at the intersection. It is something like,
Current Date Feb, 29, 2024 Mar 31, 2024 Apr 8, 2024
STATUS PROJ MONTH
Pending Sep (2024) 5000000 100000000 0
Completed Aug(2024) 80000000 900000000 8000000
The date column should display, the last days of the previous two months and the current date of the current month dynamically. for ex, if today is Apr, 8, 2024, it should display data for Feb 29, 2024 Mar 31, 2024 April 8, 2024 as shown above and if today is Apr 9, 2024, it should display data for Feb 29, 2024 Mar 31, 2024 April 9, 2024 Currently we are able to do this by manually setting the filters on Date column above to the specific days regularly. How can this be automated/calculated so that it automatically shows the intended dates?
As this is not feasible in the story, could anybody suggest/guide me on using a script for achieving this? I would like to convert the story to Optimized Design Mode and try a script. I only have basic knowledge of javascript so would appreciate it if any clues or sample script is provided.
Cheers,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.