Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide Intermediate Levels in Date Dimension
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Book for Intermediate to advanced Excel | Excel Discussion (Misc queries) | |||
How to get intermediate value of cell formula | Excel Discussion (Misc queries) | |||
Hide Middle Levels | Excel Discussion (Misc queries) | |||
What is contained in excel intermediate? | Excel Discussion (Misc queries) | |||
Intermediate value of a set of array. | Excel Worksheet Functions |