Aggregate Filter

From Sage Intelligence Knowledgebase
Jump to: navigation, search

I would like to apply an aggregate filter (Count) to a number of columns.

Is there a quick way in Alchemex to apply the aggregate to multiple columns?

Yes, by right clicking on the selected columns and applying the aggregate filter.

Method

1.Select the columns

2.Rightclick and select Apply Aggregate

Aggregate Filter

3.Select the function you would like to apply across the columns

Aggregate Filter

4.Select OK

5.The aggregate function will now be applied to multiple columns

Aggregate Filter