Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Assuming you have a Dimension with 5 levels: Year, Quarter, Month, Week and Day
Using OWC 11, you could drag the Day level to the pivot table, and you'd see all the days one below the other. Now with Excel 2007, you drag the Day level and Excel decides to behave as if you had dragged the Year level: It shows all the years below one another. You must then expand the year level so that the quarters appear, and then right-click on a year, choose "show/hide fields" and click on Year to hide the year level. Do it again for Quarter, then again for Month, and finally for week. A total of 17 clicks for something that needs 1 click with OWC 11. This is driving our users nuts. Am I missing something ? Is there a better way to do this ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need Help, this is driving me nuts | Excel Discussion (Misc queries) | |||
question driving me nuts | New Users to Excel | |||
Sum and Count are driving me nuts!! | Charts and Charting in Excel | |||
Driving me nuts. Need more nested than 7 | Excel Discussion (Misc queries) | |||
Excel / VB is driving me nuts!! | Excel Worksheet Functions |