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

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

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