# Stacked Pins on the same location instead of showing total people for that location

**URL:** <https://community.glideapps.com/t/stacked-pins-on-the-same-location-instead-of-showing-total-people-for-that-location/6282>\
**Category:** Ask for Help\
**Created:** [April 2, 2020, 4:44am UTC](https://community.glideapps.com/t/stacked-pins-on-the-same-location-instead-of-showing-total-people-for-that-location/6282 "2020-04-02T04:44:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sisa\_Lleses](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sisa_lleses/32/5021_2.png) [@Sisa\_Lleses](https://community.glideapps.com/u/Sisa_Lleses)\
**Post date:** [April 2, 2020, 4:44am UTC](https://community.glideapps.com/t/stacked-pins-on-the-same-location-instead-of-showing-total-people-for-that-location/6282/1 "2020-04-02T04:44:18Z")

</div>

I’m trying to show how many people have selected a city for their current location. However, users are families, and the a representative of each family is signing up for all the members of the family.

My sheet looks like this:

 ![Screen Shot 2020-04-02 at 12.33.50 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/8f6383c9b28d680962e62f528c54735a5dcdd666.png)

It’s displaying like this as a list. You can see it doesn’t add up the Total Travellers per city but that’s because I don’t have a formula in place. Maybe I’ve been awake too long but I can’t figure out how to go about it.

 ![Screen Shot 2020-04-02 at 12.34.01 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/afa434a71601cdd1dcc2d36430af01d928eac9c5.png)

As a result, I get stacked pins.

 ![Screen Shot 2020-04-02 at 12.36.05 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/f54c036190c79a3d86c7d4e6b172ec442624bf8c.jpeg)

But the charts were easier to work with:

 ![Screen Shot 2020-04-02 at 12.37.10 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/3e1157f393f6e5176e4f7ade20f043dc885c9daf.png)

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [April 2, 2020, 5:29pm UTC](https://community.glideapps.com/t/stacked-pins-on-the-same-location-instead-of-showing-total-people-for-that-location/6282/2 "2020-04-02T17:29:52Z")

</div>

At this point Glides Rollup column does not have the ability to add a Filter condition, so that calculation would need to be done in the sheet with a sumif formula.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [April 5, 2020, 6:43pm UTC](https://community.glideapps.com/t/stacked-pins-on-the-same-location-instead-of-showing-total-people-for-that-location/6282/3 "2020-04-05T18:43:07Z")

</div>

I would use a query in the sheet to fill a new tab with unique cities and the sum of all the people. Or like @George_B said, build a new sheet using the UNIQUE formula to get a unique list of cities, then use a SUMIF to total up all the people for that city.