Get Top 2

[Anonymous]

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.

[Anonymous · Accepted solution]

=if(Aggr((Count(Application) / Count(DISTINCT Rating)),Customer) >= 2,Customer)