Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to know how to incluse a set analysis into the following formula
=Aggr(if(rank(sum(Sales))<=3,Clustomers),Clustomers)
as i want to obtain in a table the top 3 customer for sales but for a specific activiti, so that I need to inclued a prefilter in this formula as {ACTIVITY = 'COP. TASSO'}
Thanks in advance
if i understood correctly
=Aggr(if(rank(sum({<ACTIVITY={'COP. TASSO'}>}Sales))<=3,Clustomers),Clustomers)