LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
sergv
 
Posts: n/a
Default Pivot table-show all grouped items


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


--
sergv
------------------------------------------------------------------------
sergv's Profile: http://www.excelforum.com/member.php...o&userid=26927
View this thread: http://www.excelforum.com/showthread...hreadid=401969

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Keep conditional format when "show pages" from Pivot table Angus Excel Discussion (Misc queries) 7 June 30th 05 01:33 PM
Pivot table show pages but omit those without data Angus Excel Discussion (Misc queries) 0 June 16th 05 06:04 PM
Pivot table, dynamic data formula Excel GuRu Excel Discussion (Misc queries) 3 May 3rd 05 10:45 PM
How do I show summary totals from a pivot table on a bar chart Colleen T Charts and Charting in Excel 5 January 22nd 05 01:41 AM
Pivot Table - Group by Month - Show Items with no data Dan Reynolds Excel Discussion (Misc queries) 0 November 28th 04 01:01 AM


All times are GMT +1. The time now is 06:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"