Hi All,
On selection of year from dropdown the list table should display selected year as well as previous year. But right now it shows only data for the selected year not the previous year. I have used aggregated measures to calculate previous year GP and Variance between current and previous year. I have created these measures using periodic functions. The data type of the Year in the dropdown is date.
PFA the screenshots
Thanks for the hel
Hello,
If you look at the expression for your aggregated measures, you might see an parameter on the periodic operator that says "_ApplyAllFilters_". (I believe this was added in the 7.4 release.)
If you change that parameter to "_IgnoreAllTimeFrameFilters_" or "_IgnoreInteractiveTimeFrameFilters_", your list table should the previous years' values as desired.
If you have an earlier VA release, then you might be able to work around the issue by pre-calculating the values in your data query.
Thanks,
Sam
Hello,
If you look at the expression for your aggregated measures, you might see an parameter on the periodic operator that says "_ApplyAllFilters_". (I believe this was added in the 7.4 release.)
If you change that parameter to "_IgnoreAllTimeFrameFilters_" or "_IgnoreInteractiveTimeFrameFilters_", your list table should the previous years' values as desired.
If you have an earlier VA release, then you might be able to work around the issue by pre-calculating the values in your data query.
Thanks,
Sam
Great! Thanks for following up with us 🙂
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.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.