how to exactly copy a pivot table's formats

bigdan

Well-known Member
Joined
Oct 5, 2009
Messages
782
i'm trying to learn a few new reports at work. one of the things i need to do is based on a pivot table. i've been able to create the data just fine but i'd really like to make it look like the previous person who did this.

i can't seem to find a way to see all the formats applied to a pivot table. for example for the report layout i don't actually know the diff b/w compact, outline, and tabular forms, so i had to apply each of them individually to my pivot to see which one he used. similar idea for various other options.

is there a field to go to to see all the options applied to the pivot? our pivots are of diff sizes so I can't just copy his then paste format on mine.

And one thing I'm particularly confused about. Here's an example of what his pivot looks like. If I goto Report Layout and choose "Repeat all items" it doesn't appear this way, and if I choose "Do not repeat" it also doesn't appear this way. So I'm not sure how he did this? The fact that Opp ID doesn't show up in every row when it's the same, but all other data does.


Opportunity IDClientClassificationProb
ABCWalmartNew50%
WalmartUpsell60%
DEFAmazonNew60%
AmazonNew70%
AmazonNew80%
AmazonUpsell90%

<tbody>
</tbody>



PS - i should also mention I'm having a lot of trouble figuring out his coloring scheme. Under Design he's got "None" selected, yet his is a pretty blue color. When I choose None I get this ugly sheet. Yuck. I realize I can just apply colors but if I do that, anytime I make a change, those colors disappear. With his that doesn't happen.
 
Last edited:

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,523
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
You can set the 'repeat item labels' option for individual fields.
 

Fazza

MrExcel MVP
Joined
May 17, 2006
Messages
9,368
Copy the pivot table then change its source data from what it is initially to the data you want.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,543
Messages
5,529,456
Members
409,879
Latest member
Aussie_Excel_Wanna_Be
Top