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.
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,204
Messages
5,527,401
Members
409,760
Latest member
zeeshansyed

This Week's Hot Topics

Top