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
|