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