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: 1
Default Excel pivot tables - specific expand/collapse buttons visibility

I have a data source table 'table1' with empty cells in it like this:

P1 P2 P3 A B
0 001 001-01 100 0
0 001 001-02 0 15
0 002 25 0
0 003 003-01 58 0

I create pivot table (p1, p2, p3 rows; A, B values) with datasource 'table1'
and i get (-/+ = collapse/expand):

- 0 183 15

- 001 100 15

- 001-01 100 0
- 001-02 0 15

- 002 25 0

- 25 0

- 003 58 0

- 003-01 58 0

There is a collapse/expand button under 002 based on empty cell showing no
information, i would like not to show just this one collapse/expand button,
is it possible?



 
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
Help Needed: Pivot Expand/Collapse Buttons Not Showing For 2 Cubes 578117 Excel Discussion (Misc queries) 0 October 2nd 09 06:05 PM
Pivot Table Expand Collapse not showing for Cube 578117 Excel Discussion (Misc queries) 2 October 1st 09 10:24 PM
Expand Collapse Buttons Keith H[_2_] Excel Discussion (Misc queries) 0 April 17th 09 08:47 PM
Expand/Collapse Buttons for hidden rows or colums Vineet Anand Excel Discussion (Misc queries) 2 March 30th 09 01:12 PM
Collapse/Expand Buttons in a Pivot Table CindyC3 Excel Worksheet Functions 0 July 23rd 08 01:20 AM


All times are GMT +1. The time now is 07:26 PM.

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"