Pivot Table - Hide a column question

csotherland

New Member
Joined
Aug 12, 2004
Messages
10
Hello - I am having difficulty hiding columns in the pivot table that I've put together. The problem is as follows:

I have actual and budget data in the report columns for multiple years. I would like to show 2005 actual next to 2006 budget. I need to hide away only the 2004 and 2006 actual columns and the 2005 budget column.

If you can answer this one, you would totally make my day!!!!!!

Thanks.
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
You can hide columns in the normal way by right clicking the column header and choosing Hide. But that way I guess you lose your Year heading.

The only way I can think of is to add a column to your data concatenation Year with Actual/Budget and using that in place of the existing columns.
 

Forum statistics

Threads
1,141,142
Messages
5,704,529
Members
421,353
Latest member
jekoxien15

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top