# Fetch top 5 cities by sales revenue to show in chart

**URL:** <https://community.glideapps.com/t/fetch-top-5-cities-by-sales-revenue-to-show-in-chart/24047>\
**Category:** Ask for Help\
**Created:** [March 10, 2021, 6:20am UTC](https://community.glideapps.com/t/fetch-top-5-cities-by-sales-revenue-to-show-in-chart/24047 "2021-03-10T06:20:25Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nitesh\_Aggarwal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nitesh_aggarwal/32/19941_2.png) [@Nitesh\_Aggarwal](https://community.glideapps.com/u/Nitesh_Aggarwal)\
**Post date:** [March 10, 2021, 6:20am UTC](https://community.glideapps.com/t/fetch-top-5-cities-by-sales-revenue-to-show-in-chart/24047/1 "2021-03-10T06:20:26Z")

</div>

I have made a sales app, where I have a column of “City” from which order is placed. Now I want to show these cities in a Pie chart, but only **top 5** or top 10… **NOT all**. Can anyone suggest a way how to do this … ?

 ![ul-top](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/7/d70eaf10bfea9c56e31f067f3c29c5bafa7e2ef4.png)

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [March 10, 2021, 6:45am UTC](https://community.glideapps.com/t/fetch-top-5-cities-by-sales-revenue-to-show-in-chart/24047/2 "2021-03-10T06:45:05Z")

</div>

Use in app sort by amount, and then limit number of showing items, or in Google sheets use function sort+filter, add arrayformula(row()) then in glide filter rows that are lesser than 6