Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
hi
use this expression :count(aggr( if(Date = max(total<user> Date), user),user,vp))
with vp as your dimension