Repeating rows in pivot table - how to

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

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)
 
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
 
So it can't be done thru pivottable itself. That's sad.
Thanks for info and that trick for filling blank cells.

Tom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top