LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
doco
 
Posts: n/a
Default Drill Down in PivotTables

I have a data table listing various attributes (columns) of sale items
(rows). I have created a pivot table on this array. In the pivot table I
have asked for row data on 'size' and column data on 'category' then data on
average of 'price'. All works fine except when selecting the drop down on
'category' I cannot UNCHECK items in the resulting listbox. This happens
periodically with any PivotTable I make and seems to be no ryme or reason
behind this frustrating fallderall!

Under 'Table Options' the 'Enable Drilldown' checkbox is checked...

Any suggestions as to a configuration I have missed or ??? would be greatly
appreciated.

TIA
doco


 
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
Pivot Table Drill Down Number Formatting Gregg Riemer Excel Discussion (Misc queries) 1 January 4th 05 10:53 PM
Show one total summary but have drill down to detail Kharpo7 Excel Discussion (Misc queries) 1 December 20th 04 04:50 PM


All times are GMT +1. The time now is 05:55 PM.

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

About Us

"It's about Microsoft Excel"