Calculate row-wise difference from group statistic in VA

[paul_e]

Hello,

I need to count the number of individuals for each group that fulfil a requirement regarding the group, for instance: How many individuals in a group have a difference of less than 2 from the group average? When I try to create the corresponding calculated item in VA I get the following error since VA won't combine non-aggregated and aggregated values with numeric operators:

"Operand can only be aggregated, but this operator does not support aggregation"

[paul_e]

I understand that I can persist the aggregated values in a new aggregated table but this will cause a loss of interactivity since the aggregated table doesn't get updated when report parameters change.

[BrunoMueller]

Providing sample data and expected result will help in understanding what you want.

You can mock up something with sashelp.cars, this is available in every SAS installation.

In my experience when you use control objects on page or report level they will also filter aggregated data sources.

Also have a look at the AggregateCells operator, as this allows you to define a different bygroup for aggregation as is used on the object. 

[BrunoMueller]

The last paragraph should be:
Also have a look at the AggregateTable operator, as this allows you to define a different bygroup for aggregation as is used on the object.