LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 34
Default PivotTable Columns

I have a sheet full of data with these column names:

Client Name
Billing Method
Billing Type
Product / Service
Category
Jan-04
Feb-04
Mar-04
Apr-04
May-04
Jun-04
Jul-04
Aug-04
Sep-04
Oct-04
Nov-04
Dec-04
Totals

In my PivotTable, I put "Billing Type" and "Product / Service" as column
fields and put "Totals" as a data item. What I want to do is see column
totals of each type and service per month, but when I add "Jan-04" as a
column, it gives me totals of that month as well.

Can anyone help me out so that all i see in the columns is the months and
the rest of the data is broken up to show the total per billing type and
service.

Thanks


 
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
PivotTable Sum 2 Columns Mouimet Excel Worksheet Functions 1 November 20th 09 12:55 AM
How do I get PivotTable data results to show in columns instead ro GeorgeK@Novagard Excel Discussion (Misc queries) 4 April 23rd 08 06:36 PM
Pivottable columns multiply in excel 2007 Haffi Excel Worksheet Functions 1 August 21st 07 04:32 AM
Show % between two columns in a pivottable dq Excel Worksheet Functions 2 May 7th 07 06:46 PM
PivotTable columns not going Invisible Stoney Excel Programming 0 November 5th 03 10:26 PM


All times are GMT +1. The time now is 08:35 AM.

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"