|
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
|