Hiding fields in PivotTable

[kollur]

Hi All,
Could someone please help me with the following:
I send out an excel file to my managers that has expense details summarized from a Pivot table that is created from a data dump from my GL. The data dump has many columns but I pivot on certain columns only. If my Manager wants to look into the details that have, say , gone into fuel cost, then he double clicks on that cell, and the details are shown in a new sheet.

My problem is that the new sheet displays all the columns that are existing in the original data file, and this confuses the Manager. Is there any way that I could hide selected fields from viewing as and when the cells are double clicked for details?

The only option that I could think of is to do away with the columns in the main data table from where I pivot, and this would be a long and painful process every month!

I hope I could state my problem clearly, and if it is not the case then I will attach a sample file.

Thanks a bunch in advance for your help!

Cheers,
SJ

[humdingaling]

you didnt put down what excel version your using
if you are using 2010+ then you can use pivot table slicers
http://www.contextures.com/excelpivottableslicers.html
slicers are easier way of filtering data

if this is no good then yes attach sample file
with before and expected after