I have an old spreadsheet where I have two pivot tables. One has a filter set that lets me hide individual columns of data, the second does not but I'd like to. Problem is, I can't figure out how I did it for the other in the first place.
The data set that is the source for the pivot table has x, y, and color values (red, yellow, green, null and N/A) for each instance (row) of data. When I built my pivot table I used the colors as a major heading with X and Y under that, such that the pivot table has 3 pairs of X and Y columns, each under one of the three colors. The color fields of "N/A' and 'Null" I don't want to see and somehow I filtered those out...and can't figure out how.
Above the color label row there is another row with "Column Labels" and a drop down box where I can select/deselect the "color" columns...here is where "null" and "N/A" are deselected.
How did I do this? Seriously, it's been 3 years and I can't figure this out for the life of me.
Office 2007 by the way..
Thanks
The data set that is the source for the pivot table has x, y, and color values (red, yellow, green, null and N/A) for each instance (row) of data. When I built my pivot table I used the colors as a major heading with X and Y under that, such that the pivot table has 3 pairs of X and Y columns, each under one of the three colors. The color fields of "N/A' and 'Null" I don't want to see and somehow I filtered those out...and can't figure out how.
Above the color label row there is another row with "Column Labels" and a drop down box where I can select/deselect the "color" columns...here is where "null" and "N/A" are deselected.
How did I do this? Seriously, it's been 3 years and I can't figure this out for the life of me.
Office 2007 by the way..
Thanks
