Hi merryquant,

I believe you want to use the filters and sort of a simple table instead of Pivot Tables. Pivots will sum or count the numbers of things. Because you want to keep the location (which is text) you need to not use a Pivot. Simply filter a table of data by two different columns and see if that isn't what you are after.