4 Replies Latest reply: Nov 4, 2016 2:59 AM by Jonathan Dienst RSS

    How to get the data from range 5th to 10th ?

    Allison Fang

      Hi all,

      I am trying to get the cities which have the total number of arrivals ranked from 5th to 10th.

      This is the set analysis I have for now but seems doesn't work:

       

      SUM({<Arrival_MonthYear={'$(=max(Arrival_MonthYear))'},[Country of Residence] = {"=Rank(sum({<[Country of Residence]=>}[Number of Arrivals]))={“<=(=25)>=(=15)”}"}>}[Number of Arrivals])

       

       

      Can anyone help?

      Thank you!!!

       

       

      Best Regards,

      Allison