Remove / hide unused pivot table columns

[Flytoohigh]

Excel 2010 - I have created a pivot table with YoY Count as a column. The first year has no YoY data since there is no prior year for comparison. This is resulting in YoY Count field with data for for all subsequent years except that first year. Because the pivot table will be pivoted I cannot simply hide the column. Is there a way to remove the column with no values without hiding it?


[TABLE="width: 407"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]LY[/TD]
[TD][/TD]
[TD]TY[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Region[/TD]
[TD]Month[/TD]
[TD]Count[/TD]
[TD]YoY Count[/TD]
[TD]Count[/TD]
[TD]YoY Count[/TD]
[/TR]
[TR]
[TD]Domestic[/TD]
[TD][/TD]
[TD]1,431,470[/TD]
[TD][/TD]
[TD]1,494,963[/TD]
[TD]63,493[/TD]
[/TR]
[TR]
[TD]MCLA[/TD]
[TD][/TD]
[TD]607,880[/TD]
[TD][/TD]
[TD]691,262[/TD]
[TD]83,382[/TD]
[/TR]
[TR]
[TD]Pacific[/TD]
[TD][/TD]
[TD]146,906[/TD]
[TD][/TD]
[TD]97,173[/TD]
[TD](49,733)[/TD]
[/TR]
[TR]
[TD]TransAtlantic[/TD]
[TD][/TD]
[TD]224,393[/TD]
[TD][/TD]
[TD]240,224[/TD]
[TD]15,831[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD][/TD]
[TD]2,410,649[/TD]
[TD][/TD]
[TD]2,523,622[/TD]
[TD]112,973[/TD]
[/TR]
</tbody>[/TABLE]

 

[Trevor G]

Please don't double post it is against the forum rules. If you want to add something continue using the same thread, if you want to see if someone can help once you have posted use BUMP.

https://www.mrexcel.com/forum/excel-questions/1077807-remove-null-columns-pivot-table.html