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:
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.
As a result, I get stacked pins.
But the charts were easier to work with: