Cannot repeat fields in pivot table.

Copper Contributor

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