Showing Multiple Details from a Pivot Table?

[Rayvin]

Hi Guys,

Hope everyone's having an awesome Tuesday!

I have a dilemma that for the life of me, can't figure out. Your help/advise would be greatly appreciated

So I've this pivot table which I've been manually right clicking on the values and selecting 'Show Details' to compile the source data. I can't figure out how to to open up the source data on a mass basis (rather than one by one manually) and have it all auto-compiled into a single worksheet or tab within the same workbook.

Can anyone please advise the best way to go about doing this?

[TABLE="width: 177"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Vendor[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD]PHELM[/TD]
[TD="align: right"]25[/TD]
[/TR]
[TR]
[TD]PHELM[/TD]
[TD="align: right"]24[/TD]
[/TR]
[TR]
[TD]PHELM[/TD]
[TD="align: right"]24[/TD]
[/TR]
[TR]
[TD]PHELM[/TD]
[TD="align: right"]21[/TD]
[/TR]
[TR]
[TD]GBORR5[/TD]
[TD="align: right"]14[/TD]
[/TR]
</tbody>[/TABLE]

Regards,
Rayvin

 

[liveinhope]

You would need a VBA macro to do that .. bit beyond my my VBA skill level
But there is another to show details that might meet your needs

Right-click on one of the vendor cells then select expand/collapse -> expand entire field .
select the field to expand and click OK

(one important difference is that "show detail" also shows fields that were in your source data but not shown in your pivot table. expand only shows fields that are in the pivot table. this can actually be a good thing if your soruce data has some fields you don't want people to be able to see when you get down to the detail level9