I have a table like this

Country State Cities sales
USA AL xxxx 12000
USA AL XYYY 20000
USA AL PZZZ 30000
USA AL QPPP 40000
USA AL Xppp 20000
USA AL PZZZ 30000
USA AL QPPP 40000


I need to create a pivot table that shows sales for cities that start with "X" or start with "P". So my pivot table should show like this

Cities sales

xxxx 12000
XYYY 20000
PZZZ 30000
Xppp 20000
PZZZ 30000


Thanks,