LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default 2007: pivot table driving our users nuts.

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need Help, this is driving me nuts heitorfjr Excel Discussion (Misc queries) 2 January 15th 06 03:10 PM
question driving me nuts Esaam New Users to Excel 4 December 6th 05 05:34 AM
Sum and Count are driving me nuts!! Mattrapps Charts and Charting in Excel 1 May 9th 05 07:08 PM
Driving me nuts. Need more nested than 7 Stressed Excel Discussion (Misc queries) 5 April 12th 05 06:20 PM
Excel / VB is driving me nuts!! Andrew Excel Worksheet Functions 2 November 29th 04 04:06 AM


All times are GMT +1. The time now is 11:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"