Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help Needed: Pivot Expand/Collapse Buttons Not Showing For 2 Cubes | Excel Discussion (Misc queries) | |||
Pivot Table Expand Collapse not showing for Cube | Excel Discussion (Misc queries) | |||
Expand Collapse Buttons | Excel Discussion (Misc queries) | |||
Expand/Collapse Buttons for hidden rows or colums | Excel Discussion (Misc queries) | |||
Collapse/Expand Buttons in a Pivot Table | Excel Worksheet Functions |