Consolidating Pivot Table criteria

**jomili** · 03-08-2012, 12:10 PM

The attached file is the result of a Pivot Table created by another group, from source data I can't directly access, other than by double-clicking into the pivot. I have to take the results of the pivot and use them in other reports I create. One aspect of the pivot is awkward for me, and it's related to the Program field.

Some programs need to be lumped together; for instance, 87086, 89013, and 89023 are the same program, as are 87088, 89018, and 89028 (there are others). Currently I take the pivot, paste as values, and manually make the changes in my values copy of the pivot table. Is there an automated method that would make the task easier? I'm open to any ideas.

Thanks,
John

**jomili** · 05-15-2012, 08:50 AM

Never got a reply. One is desired.

**Pichingualas** · 05-15-2012, 09:37 AM

The problem with pivot tables is that you can only change the data in them by changing the data they came from. Sadly, since you can't access that, you won't be able to make that change. What you could do is make a macro that will do what you are doing manually, I mean copy the data and make the changes you need... This would only be of use to you if the programs that need to be lumped together are always the same, as you could store that information in a macro like this. That's just my view of your situation, maybe I'm wrong..