I have a report that uses report level filters e.g extract data when the user selects the yyyy mm in question e.g 2017 01 all the data in the report only shows data for that month which is what i need to sse.
I have a variable called balance i would like to be able to see what the balance figure was for for 2016 12 i.e the previous month. I know there is a predefined agregated calculation [Variable] Difference from previous period this is ok if you do not have any filters on it. From advise in this community i develped using parameters a way to get round this however the extract date drop down list had to be in the body of the report, it would not work if the extract date filter was applied at section or report level any work arounds?
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.