1 Reply Latest reply on Sep 27, 2016 5:40 PM by Shinichiro Murakami

    Filtering Top 5 Suburbs

    Jagjit Singh

      Hi All,

       

      I have a dataset with customer count, age groups and suburbs. I'm trying to get top 5 suburbs with max customers within the age group. I used the filter option and then top 5 but for age group 0-5 i'm not getting the correct result.

      I have attached the sample workbook.

       

      Incorrect result top 5.PNG

       

       

       

      Thanks

       

      Jag