I have a pivot table (built from a ms cube using ms query) that has a date
dimension. My raw data has the Date as mm/dd/yyyy and the pivot table
automatically generates the month, quarter and year from this date. I cannot
seem to be able to display only the Year and Month (without the Quarter). I
can show the top level of the dimension (Year) or the Months alone, but I
cannot supress just the Quarter. All of the "Hide" options are greyed out for
the intermediate levels. Can anyone tell me how to do this with a Date in a
pivot table? (Excel 2003) Thanks.