aggr selection issue

[idogridish2]

Hi,

when using calculated dimension with aggr it select the user,

here is my dimension:

=Aggr(FirstSortedValue(vp, -Date), user)

can i make it select the vp?

the result in the table is correct.

please find attached qvf

thanks.

ido.

[lironbaram]

hi 

use this expression :count(aggr( if(Date = max(total<user> Date), user),user,vp))

with vp as your dimension