Hi,
I've run into a problem of how to repeat rows in my pivot table PT
with the intent of not having any empty cells in PT. Currently what I
have is:

Customer Name Customer ID Values
ABC1 100 Count
(goods)

Sum (revenue)

Avg (price)
ABC2 200 Count
(goods)

Sum (revenue)

Avg (price)
-------------------------------------------------------------------------------------------------------
but I whis to have:
Customer Name Customer ID Values
ABC1 100 Count
(goods)
ABC1 100 Sum
(revenue)
ABC1 100 Avg
(price)
ABC2 200 Count
(goods)
ABC2 200 Sum
(revenue)
ABC2 200 Avg
(price)
-------------------------------------------------------------------------------------------------------
Is it a way to accomplish this ?
Thanks for suggestions.
Tom

Not 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

Tom wrote:

Hi,
I've run into a problem of how to repeat rows in my pivot table PT
with the intent of not having any empty cells in PT. Currently what I
have is:

Customer Name Customer ID Values
ABC1 100 Count
(goods)

Sum (revenue)

Avg (price)
ABC2 200 Count
(goods)

Sum (revenue)

Avg (price)
-------------------------------------------------------------------------------------------------------
but I whis to have:
Customer Name Customer ID Values
ABC1 100 Count
(goods)
ABC1 100 Sum
(revenue)
ABC1 100 Avg
(price)
ABC2 200 Count
(goods)
ABC2 200 Sum
(revenue)
ABC2 200 Avg
(price)
-------------------------------------------------------------------------------------------------------
Is it a way to accomplish this ?
Thanks for suggestions.
Tom

--

Dave Peterson

So it can't be done thru pivottable itself. That's sad.
Thanks for info and that trick for filling blank cells.

Tom

Dave Peterson wrote:
Not and keep it a pivottable.