Pivot table-show all grouped items

S

sergv

I am very frustrated as I think this is very doable, but I just don't
know how to do this...so I have a pivot table:

USA
| June | Volume
| July | Volume
Canada
| June | Volume
| July | Volume
etc...
(except first line for each country is on the same line-i am having a
hell of a time trying to format posts for this board)
But I want this pivot table report to show in a tabular format, meaing
that the countries should show up on each page:

USA | June | Volume
USA | July | Volume
Canada | June | Volume
Canada | July | Volume

etc.

I several more groups and want all of them to show up on each
line...Thx
 
D

Debra Dalgleish

The row headings show once in a Pivot Table, and there's no setting you
can change, to force them to repeat.

To create the table with a heading on each row, you could copy the
table, paste it as values in another location, and fill the blanks,
using the technique shown here:

http://www.contextures.com/xlDataEntry02.html
 

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

Similar Threads

Sort pivot table field (droplist) by month or original data 1
Reverse Pivot-type Data (that's not a pivot table) 2
Pivot Table and adding a % column, that is not in original data 3
How do I replace/select new fields in pivot table using a macro? 1
Pivot Table Date Groups 2
Pivot tables 2
pivot table and grouping 4
Pivot table sum issue 5

Top