Log In
Register
Home
Active Member
April 12, 2023
Offline
when nothing is selected it is only showing total squares of first value instead of summing all together. When you select slicer of different brand the total squares updates. Not sure what I am doing wrong and I am new to this forum and how to get the pertinent information on here to elicit help. Table layout below
CountyStateSquareBrandStyle
| Sussex | Delaware | 51.66 | CertainTeed | Landmark PRO |
| Sussex | Delaware | 16.00 | TAMKO | Heritage |
| Sussex | New Jersey | 16.08 | CertainTeed | Landmark PRO |
| Sussex | New Jersey | 13.00 | TAMKO | Heritage |
July 16, 2010
Offline
Hi Brett,
Map charts require you to summarise the data into states or countries. You can do this with a PivotTable and then build a regular chart from the PivotTable.
See example file attached.
Mynda
Active Member
April 12, 2023
Offline
I have the details down to County and state. I believe I have met the limitations of the map chart by trying to add another layer to my slicer. File attached, tab labeled Brand_Map
I appreciate your help. What I am trying to illustrate is without anything selected on the slicer for Brand/Style it will show total squares for the State, County, almost like a sum if statement within the table but I am not sure how to execute that IF it is even possible.
1 Guest(s)
