Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
PIVOT TABLE ????
COLUMN: INVOICE # INVOICE DATE AMOUNT$ 101 9/18/07 100 101 TOTAL 100 102 9/20/07 200 102 TOTAL 200 GRAND TOTAL 300 MY QUESTION IS HOW DO I ELIMINATE EACH ROW TOTAL? I TRIED PIVOT TABLE OPTIONS CLICK OFF GRAND TOTAL FOR ROW THAT DIDN'T WORK AND NOT I'M LOOKING FOR. ONE LAST OPTION TO HIDE EACH ROW TOTAL WHICH IS VERY TEDIOUS EXTREMLY LONG PROCESS I DIDN'T WANT TO DO. IS THERE A FORMULA OF SOME SORT? THANKS FOR YOUR HELP SOTHEA |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
PIVOT TABLE ????
Double-click on the field button for Invoice #
Under Subtotals, click None, then click OK Soth wrote: COLUMN: INVOICE # INVOICE DATE AMOUNT$ 101 9/18/07 100 101 TOTAL 100 102 9/20/07 200 102 TOTAL 200 GRAND TOTAL 300 MY QUESTION IS HOW DO I ELIMINATE EACH ROW TOTAL? I TRIED PIVOT TABLE OPTIONS CLICK OFF GRAND TOTAL FOR ROW THAT DIDN'T WORK AND NOT I'M LOOKING FOR. ONE LAST OPTION TO HIDE EACH ROW TOTAL WHICH IS VERY TEDIOUS EXTREMLY LONG PROCESS I DIDN'T WANT TO DO. IS THERE A FORMULA OF SOME SORT? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
PIVOT TABLE ????
great ! thank you Deby.
"Debra Dalgleish" wrote: Double-click on the field button for Invoice # Under Subtotals, click None, then click OK Soth wrote: COLUMN: INVOICE # INVOICE DATE AMOUNT$ 101 9/18/07 100 101 TOTAL 100 102 9/20/07 200 102 TOTAL 200 GRAND TOTAL 300 MY QUESTION IS HOW DO I ELIMINATE EACH ROW TOTAL? I TRIED PIVOT TABLE OPTIONS CLICK OFF GRAND TOTAL FOR ROW THAT DIDN'T WORK AND NOT I'M LOOKING FOR. ONE LAST OPTION TO HIDE EACH ROW TOTAL WHICH IS VERY TEDIOUS EXTREMLY LONG PROCESS I DIDN'T WANT TO DO. IS THERE A FORMULA OF SOME SORT? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Pivot Table - Use Other Pivot Table as Data Source | Excel Discussion (Misc queries) | |||
How do I sort pivot table data outside a pivot table | Excel Worksheet Functions | |||
Pivot Table Chart - With Pivot Table Totals | Charts and Charting in Excel | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel |