See
http://peltiertech.com/Excel/Pivots/pivotstart.htm
--
HTH
RP
(remove nothere from the email address if mailing direct)
"expicitd" wrote in message
...
how do i create a pivot table?
"Peo Sjoblom" wrote:
Use either pivot table or datasubtotal
--
Regards,
Peo Sjoblom
"expicitd" wrote in message
...
Question how can I use the SUM command to have it list the grand total
for
a
wtn everytime time it changes?
Example data
WTN BillAMt
1111111 1.00
1111111 4.26
1111111 5.32
1111111 8.62
2222222 9.36
2222222 83.20
2222222 15.20
2222222 8.20
End result
WTN BIllAmt
1111111 19.20
2222222 115.96