Excel pivot tables - specific expand/collapse buttons visibility

  • Thread starter MichaÅ‚ Lenartowicz
  • Start date

M

Michał Lenartowicz

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?
 
Ad

Advertisements

R

Roger Govier

Hi Michael

I don't think that this is possible.
You can only Turn Drill Indicators Off or On, not choose for specific row
values.

--
Regards
Roger Govier

Michał Lenartowicz said:
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?




__________ Information from ESET Smart Security, version of virus
signature database 4520 (20091018) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4520 (20091018) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top