About Hiding Fields in Pivot Tables
 

Hi,

I am working in a Pivot table. I have data analysed by each month of years
2000-2005. I hide monthes 1-12 for years 2000 - 2003 so that only the total
of the year shows. But in year 2004 I only want to hide monthes 1-10, that is
i want months 11 and 12 to show. If I hilight a month and click on "hide
detail" it hides all 12 months (and for all years). why is this happenng.

I know i could just select the hole columns (outside the pivot table) and
hide them but isn't there a more elegant way?

Please note that whicherer the display options i do want all data to be
calculated in the final outcome.

Thank you.

You could add a column to the source data table, and calculate the
year/month. For example: =TEXT(A2,"yy-mm")

Add that field to the page area of the pivot table.
Double-click the YearMonth field button, and select the months you want
to hide
Right-click a cell in the pivot table, and choose Table Options.
Add a check mark to 'Subtotal hidden page items'


bay wrote:
Hi,

I am working in a Pivot table. I have data analysed by each month of years
2000-2005. I hide monthes 1-12 for years 2000 - 2003 so that only the total
of the year shows. But in year 2004 I only want to hide monthes 1-10, that is
i want months 11 and 12 to show. If I hilight a month and click on "hide
detail" it hides all 12 months (and for all years). why is this happenng.

I know i could just select the hole columns (outside the pivot table) and
hide them but isn't there a more elegant way?

Please note that whicherer the display options i do want all data to be
calculated in the final outcome.

Thank you.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html