Pivot Table remove extra lines

[SammiBoi]

I generated a pivot table from my excel data set (roughly 100 fields and 1000 unique records and really should be an Access project in the future). After I have put all of the pivot table filters/creterias in, I will double click to drill down on certain things. I really don't need to see all of the information on the drilldown (ie: I really need about 10 of the 100 fields).

Is there a macro that would let me delete all of the unneeded columns after the drill down? Just to keep in mind, I might have to add a few more column in the data set so using the macro recorder to delete certain rows probably won't work for me.

Thanks
Sam

 

[Norie]

Sam

If you don't want the data in the drilldown why is it in the pivot table?

 

[SammiBoi]

You are right, they probably shouldn't be in the pivot table. I kept them in the pivot table data set because it was easier to make the pivot table that way..... Furthermore, a lot of the fields are only for sorting purposes and are not useful to me after I run the drilldown.

This is why I want the macro to help me delete some of these columns.

 

[SammiBoi]

Let me know if I can clarify anything so that you might be able to help me better.