If the expense accounts are in the Column area, you can click the arrow
on the dropdown for the field heading. Then, remove the check marks for
the expense accounts that you don't want see.

Jimmy wrote:
I have a spreadsheet that has a row of stores starting in column A and the
column headers are all expense accounts going across the spreadsheet. Is
there a way to create a pivot table so I can pick and choose which columns I
want to see? I can't seem to figure it out. I can't drop the expense
accounts in the column portion because no data will populate.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html