I am trying to make a pie chart containing the number of retail employees per city. There are two columns I am trying to use. The first contains the name of the city, and the second the number of employees. Since each city has different zones, there are multiple rows that have the same city name. When I make the pie chart, it creates a slice for each zone rather than each city. Is there a way to merge these zones together? I attached an example.
Bookmarks