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

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 wrote:

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

Thank you. I will try your macro.

"Dave Peterson" wrote:

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 wrote:

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