I have two fields selected for row data. One field is product number and the
other field is location. There are 3 locations for every product. In the
pivot table I have the product number in the first column followed by the
location. I need to have the product number on each row next to the location
instead of the pivot table default of listing the product only once. Is
there a way to select this?

Not possible to do this and keep it a pivottable.

I copy the pivottable to a new worksheet and paste|special values. That copy is
no longer a pivottable, but I can do anything I want to the data.

Including following these techniques from Debra Dalgleish's site:
http://contextures.com/xlDataEntry02.html

ekazakoff wrote:

I have two fields selected for row data. One field is product number and the
other field is location. There are 3 locations for every product. In the
pivot table I have the product number in the first column followed by the
location. I need to have the product number on each row next to the location
instead of the pivot table default of listing the product only once. Is
there a way to select this?

--

Dave Peterson

Thanks for the help, I never would have figured that out.

"Dave Peterson" wrote:

Not possible to do this and keep it a pivottable.

I copy the pivottable to a new worksheet and paste|special values. That copy is
no longer a pivottable, but I can do anything I want to the data.

Including following these techniques from Debra Dalgleish's site:
http://contextures.com/xlDataEntry02.html

ekazakoff wrote:

I have two fields selected for row data. One field is product number and the
other field is location. There are 3 locations for every product. In the
pivot table I have the product number in the first column followed by the
location. I need to have the product number on each row next to the location
instead of the pivot table default of listing the product only once. Is
there a way to select this?

--

Dave Peterson

Debra has lots of good stuff at that site. You may want to bookmark it.

ekazakoff wrote:

Thanks for the help, I never would have figured that out.

"Dave Peterson" wrote:

Not possible to do this and keep it a pivottable.

I copy the pivottable to a new worksheet and paste|special values. That copy is
no longer a pivottable, but I can do anything I want to the data.

Including following these techniques from Debra Dalgleish's site:
http://contextures.com/xlDataEntry02.html

ekazakoff wrote:

I have two fields selected for row data. One field is product number and the
other field is location. There are 3 locations for every product. In the
pivot table I have the product number in the first column followed by the
location. I need to have the product number on each row next to the location
instead of the pivot table default of listing the product only once. Is
there a way to select this?

--

Dave Peterson


--

Dave Peterson