Hello!
I am trying to build an inventory map where a person can enter a SKU into a search feild, then bubbles will appear over locations on the USA map where the inventory is located. I also would like the size of the bubble to reflect the amount of inventory compared to other locations.
-Straight forward data I have is warehouse zip codes (gets me the position of the bubbles on the map)
-Each warehouse has a unique name
-I have a general ledger that is updated live, that shows SKU, WAREHOUSE, QTY.
I need help in how to filter the data for the map as the user changes the sku. I am guessing I would need count functions that count QTY per WAREHOUSE which gives the value for the bubble size......but would need this to work with ALL SKUS and filtered SKUS.
Any help would be appreciated!
