I am attempting to create a heat map of our nationwide sales for the last 15 years. I have a 40 column sheet (roughly 80,000 rows) of each item we have shipped in that time frame. I have condensed it into a power pivot of 3 columns: the zip code, the date of the shipment, and the $ of the shipment. I can go to the time drop down block and adjust the data I want shown on the map to show total sales for a year (or month, depending on what I set the filter at). I would like some help on a couple items. Can I get the map to play a tour switching to our yearly sales? Do I need to formulate my data into bigger blocks?
Thanks
Brent
Thanks
Brent
