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

PivotTable Columns
 

Move Billing Type and Product/Service to the Row area
Put each month in the Data area.

To see column or row totals, right-click on a cell in the pivottable
Choose Table Options, and add check marks for Grand totals.

To hide the Subtotals, double-click on the Billing Type button, and
choose to Summarize by 'None'

Dominique Feteau wrote:
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




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html