I have data that contains the sales per 3 different customers per the 14 states in Germany and I wish to be able to see all the sales on the map and to be able maybe have a filter of the customers. My current challenge is: the map only shows me the sales of one the customer despite selecting all the data.
When I use the Filled Maps option from excel on this data, the map only shows me the data for StoreAA. I want to be able to see the overall sale for the 3 retailers and then maybe have a filter option to select the retailer.
| Retailer | State | Country | sale |
| StoreAA | Baden-Wurttemberg | DE | 1000 |
| StoreAA | Bavaria | DE | 501 |
| StoreAA | Berlin | DE | 502 |
| StoreAA | Brandenburg | DE | 503 |
| StoreAA | Bremen | DE | 504 |
| StoreAA | Hamburg | DE | 505 |
| StoreAA | Hesse | DE | 506 |
| StoreAA | Lower Saxony | DE | 507 |
| StoreAA | Mecklenburg-Vorpommern | DE | 508 |
| StoreAA | North Rhine-Westphalia | DE | 509 |
| StoreAA | Rhineland-Palatinate | DE | 510 |
| StoreAA | Saarland | DE | 511 |
| StoreAA | Saxony | DE | 512 |
| StoreAA | Saxony-Anhalt | DE | 513 |
| StoreAA | Schleswig-Holstein | DE | 514 |
| StoreAA | Thuringia | DE | 515 |
| StoreBB | Baden-Wurttemberg | DE | 516 |
| StoreBB | Bavaria | DE | 517 |
| StoreBB | Berlin | DE | 518 |
| StoreBB | Brandenburg | DE | 519 |
| StoreBB | Bremen | DE | 520 |
| StoreBB | Hamburg | DE | 521 |
| StoreBB | Hesse | DE | 522 |
| StoreBB | Lower Saxony | DE | 523 |
| StoreBB | Mecklenburg-Vorpommern | DE | 524 |
| StoreBB | North Rhine-Westphalia | DE | 525 |
| StoreBB | Rhineland-Palatinate | DE | 526 |
| StoreBB | Saarland | DE | 527 |
| StoreBB | Saxony | DE | 528 |
| StoreBB | Saxony-Anhalt | DE | 529 |
| StoreBB | Schleswig-Holstein | DE | 530 |
| StoreBB | Thuringia | DE | 531 |
| StoreCC | Baden-Wurttemberg | DE | 532 |
| StoreCC | Bavaria | DE | 533 |
| StoreCC | Berlin | DE | 534 |
| StoreCC | Brandenburg | DE | 535 |
| StoreCC | Bremen | DE | 536 |
| StoreCC | Hamburg | DE | 537 |
| StoreCC | Hesse | DE | 538 |
| StoreCC | Lower Saxony | DE | 539 |
| StoreCC | Mecklenburg-Vorpommern | DE | 540 |
| StoreCC | North Rhine-Westphalia | DE | 541 |
| StoreCC | Rhineland-Palatinate | DE | 542 |
| StoreCC | Saarland | DE | 543 |
| StoreCC | Saxony | DE | 544 |
| StoreCC | Saxony-Anhalt | DE | 545 |
| StoreCC | Schleswig-Holstein | DE | 546 |
| StoreCC | Thuringia | DE | 547 |
When I use the Filled Maps option from excel on this data, the map only shows me the data for StoreAA. I want to be able to see the overall sale for the 3 retailers and then maybe have a filter option to select the retailer.
