Cannot repeat fields in pivot table.

%3CLINGO-SUB%20id%3D%22lingo-sub-2013244%22%20slang%3D%22en-US%22%3ECannot%20repeat%20fields%20in%20pivot%20table.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2013244%22%20slang%3D%22en-US%22%3E%3CP%3EGreetings%20All-%20Has%20anyone%20encountered%20issues%20repeating%20fields%20in%20a%20pivot%20table%20row%20when%20wanting%20to%20show%20values%20in%20different%20ways%20(ie%20count%20and%20%25)%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20did%20some%20searching%20for%20workarounds.%20One%20was%20holding%26nbsp%3B%20down%20Ctrl%26nbsp%3B%20before%20dragging%20the%20field%20over%20but%20nothing%20is%20working%20so%20far.%20It%20was%26nbsp%3B%3CSPAN%3Eworking%20seamlessly%20before%20so%20I%20might%20have%20an%20Excel%20glitch.%20But%20before%20I%20go%20down%20the%20rabbit%20hole%20of%20contacting%20my%20IT%20department%20and%20what%20ends%20up%20being%20%22uninstall%20and%20reinstall%20Office%22%20and%20if%20that%20doesn't%20work%20%22re-image%22%2C%20thought%20I%20start%20here.%20I've%20been%20in%20the%20layout%20options%20a%20lot%20so%20thought%20I%20might%20have%20changed%20something%20that%20is%20interfering.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThank%20you!%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ECatherine%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2013244%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Greetings All- Has anyone encountered issues repeating fields in a pivot table row when wanting to show values in different ways (ie count and %)? 

 

I did some searching for workarounds. One was holding  down Ctrl  before dragging the field over but nothing is working so far. It was working seamlessly before so I might have an Excel glitch. But before I go down the rabbit hole of contacting my IT department and what ends up being "uninstall and reinstall Office" and if that doesn't work "re-image", thought I start here. I've been in the layout options a lot so thought I might have changed something that is interfering. 

 

Thank you!

Catherine

0 Replies