Repeating Row Fields in a pivot table


G

Guest

Is it possible to get my row fields to repeat with every row instead of
having the row field appear once as a header for all related data?
example:
in a sales table by area:
ROWS COLOMS
Area1 11111
22222
31142
Area2 45354
54534
===================
Can I get "Area1" to repeat with all its sales values and so Area2 too?
 
Ad

Advertisements

G

Guest

Thank Max for this.
But this solution is only applicable if i copy my pivot table data and paste
in a new sheet which is not viewed as a pivot table. Is there a way to do
this as an option for pivot tables?
 
Ad

Advertisements

D

Dave Peterson

Nope.

Thank Max for this.
But this solution is only applicable if i copy my pivot table data and paste
in a new sheet which is not viewed as a pivot table. Is there a way to do
this as an option for pivot tables?
 

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

Top