PivotTable Columns

[Dominique Feteau]

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]

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'