Pivot Tables

C

cromagnon21

Does anyone knows how to display the values under the headers on the Pivot
table?
I have not been able to copy the values into a new work sheet and then
filter them.
I will show me only the header on that especific column.
Thanks to anyone that can help me.
 
D

Daryl S

Someone else may have a better way, but you can copy the whole pivot table
and paste/special/values into another worksheet. From here you can
copy/paste any cells to where you want them.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top