Hello,
I am trying to use an aggregate measure as a filter on the table, but with no success. Let’s start from the beginning, I have created an aggregated measure that calculates the average of column A. This measure is dynamic which means there are filters that affect Column A. So, the average of Column A is not a standard value. After that I need to present the values of column A that are greater than or equal to the average, is this possible? If so, how can I do this.
Thanks,
Charis
Hi @Charis_Saliaris,
in your title you ask for “filtering”, in the text you look for “presentation” of selected values.
I don’t know about a “filtering” solution in my VA 7.5 as the average (in the aggregated measure) would be recalculated with each filtering, so even theoretically one would get only a iterative process.
But there might be a presentation solution:
I can use the aggregated measure of the average in a Display rule, to white all rows with my Column A value less then the average:
If this isn’t sufficient and you have a new VA Version, maybe you will find an approach here:
SAS Visual Analytics Advanced Calculations (part 3... - SAS Support Communities
Best
Markus
Hi Markus,
Thank you for your reply.
If I have understood correct there is one way to present the values of Column A which is greater than or equal with the average is via display rules.
Also, I have tried to create a new aggregated data source, but I cannot use average (aggregated measure) as a filter.
(the photo is from SAS Visual Analytics Advanced Calculations (part 3... - SAS Support Communities)
Thank you,
Haris
Try this.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
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.