Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
I have a dataset shown in the first table and second table (See Image Screen_Shot.jpg) was created using CROSSTABLE keyword.
Now i want to get the top 2 application based on Rating where # of Survey is greater than 1.
=if(Aggr((Count(Application) / Count(DISTINCT Rating)),Customer) >= 2,Customer)
=if(Aggr((Count(Application) / Count(DISTINCT Rating)),Customer) >= 2,Customer)