Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
gthomson4
Contributor II
Contributor II

Set Analysis doesn't work

I have these two expressions in two single column tables - the tables return the same results for any and all selections on Region.

=Aggr({$} Country, Country)
=Aggr({1} Country, Country)  

I expected the 2nd table to include all countries regardless?

similarly for

=Aggr({1-$} Country, Country)

I would expect all countries not in the selection?

 

1 Reply
JordyWegman
Partner - Master
Partner - Master

Hi,

What happens when you try:

=Aggr({$} Sum(Sales), Country)
=Aggr({1} Sum(Sales), Country)  

Jordy

Climber 

Work smarter, not harder