Pivot Table report formatting

B

bobtuk

I have a pivot table which has 3 levels. But the report only shows th
value once per level, I presume for formating purposes but
specifically need them displayed.. Any ideas as to if / how I go abou
this?

eg

.aaaaa bbbbbb ccccccccccccc
. dddddddddd
. eeeeee ffffffffffffffffffff

I need it to look like ;

.aaaaa bbbbbb ccccccccccccc
.aaaaa bbbbbb dddddddddd
.aaaaa eeeeee ffffffffffffffffffff

Many Thanks!

Bo
 
D

Dave Peterson

Can you get rid of the pivottable (copy|paste special|values)?

If yes, then take a look at Debra Dalgleish's site:
http://www.contextures.com/xlDataEntry02.html

She has a manual method and a VBA routine to fill those blanks.

(Get rid of your subtotals before you convert to values, too!)

If you can't get rid of the pivottable, how about doing this against a copy of
that worksheet/pivottable.

(You can't do this if you have to keep it a pivottable.)
 
Top