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 🙂
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.