PIVOT TABLE ????

[Soth]

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

 

[Debra Dalgleish]

Double-click on the field button for Invoice #
Under Subtotals, click None, then click OK

 

[Soth]

great ! thank you Deby.

Double-click on the field button for Invoice #
Under Subtotals, click None, then click OK