Pivot Table Data

[JVM762]

I want to use the data from a pivot table in another calculation. How can I
have it list the Area (as shown below) on each line?

Example (Current Pivot Table):
Area Zone Sales
USA NE 2
NW 1
SE 0
JPN NE 0
NW 2
SE 1

Example (What I want):
Area Zone Sales
USA NE 2
USA NW 1
USA SE 0
JPN NE 0
JPN NW 2
JPN SE 1

Thanks - JVM762

 

[Dave Peterson]

Pivottables won't let you do this.

You could copy the data and paste as values (a new location or over the
original???) and then use the techniques at Debra Dalgleish's site to fill those
empty cells with the value from above.

http://contextures.com/xlDataEntry02.html

 

[JVM762]

Thank you. I will try your macro.

Pivottables won't let you do this.

You could copy the data and paste as values (a new location or over the
original???) and then use the techniques at Debra Dalgleish's site to fill those
empty cells with the value from above.

http://contextures.com/xlDataEntry02.html