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

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

      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,