Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PivotTable Sum 2 Columns | Excel Worksheet Functions | |||
How do I get PivotTable data results to show in columns instead ro | Excel Discussion (Misc queries) | |||
Pivottable columns multiply in excel 2007 | Excel Worksheet Functions | |||
Show % between two columns in a pivottable | Excel Worksheet Functions | |||
PivotTable columns not going Invisible | Excel Programming |