use powerpivot to create a blank pivottable on a new worksheet. add the following fields to the pivottable. rows warehouse: location warehouse: warehouse inventory: item number values inventory: current inventory inventory: total value 4 35 insert a slicer based on warehouse. place the upper left corner of the slicer inside the borders of cell f3. 2 36 create a 3d powermap that displays the location of all warehouses based on the city geographic type. rename the worksheet inventory.