How can I display the field label on every row?
 

I am trying to change the display layout of my pivot table so the field label
is displayed on every line. How can I get my field label "Unit" to show "01"
on each row, not as a merged cell of the "NATU" values?

Sum of ACCR$
UNIT NATU Total
01 11035 2000
11037 6580
15101 20864
15104 43681.4962
15105 59427.36
1511 158980.25
1522 78159.6683
1600 9140.7
1630 102463.256
1720 9913.552
172013 8028
1720714 162390.3507
1720812 17500
1760 4109
1764 31261.37
1765 11928.3962

How can I display the field label on every row?
 

You can't while keeping it as a pivottable.

But you could if you convert it to values (or copy|paste special|values to a
different location).

Then you could follow one of the techniques at Debra Dalgleish's site:
http://www.contextures.com/xlDataEntry02.html



MCave wrote:

I am trying to change the display layout of my pivot table so the field label
is displayed on every line. How can I get my field label "Unit" to show "01"
on each row, not as a merged cell of the "NATU" values?

Sum of ACCR$
UNIT NATU Total
01 11035 2000
11037 6580
15101 20864
15104 43681.4962
15105 59427.36
1511 158980.25
1522 78159.6683
1600 9140.7
1630 102463.256
1720 9913.552
172013 8028
1720714 162390.3507
1720812 17500
1760 4109
1764 31261.37
1765 11928.3962

--

Dave Peterson