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.