I don't have errors in the raw data, I am taking a spreadsheet of a
couple of columns - some have numbers, some are blanks - then putting
into a pivot table (count of ...) but when I try to have it changed to
get averages, etc. It doesn't work


BL-DLY (4P) BL-POD (3P) Count of BL-DLY (4P) Count of Dwell Time at
POD Count of Dwell Time POD to Rail Departure
COLLEGE PARK, GA CHARLESTON, SC 11 11 11
LOS ANGELES, CA 2 2 2
SAVANNAH, GA 7 7 7
COLLEGE PARK, GA Total 20 20 20
DALLAS, TX LOS ANGELES, CA 10 10 10
DALLAS, TX Total 10 10 10
LANGLEY, BC VANCOUVER, BC 1 1 1
LANGLEY, BC Total 1 1 1
MIRA LOMA, CA LOS ANGELES, CA 66 66 66
MIRA LOMA, CA Total 66 66 66
MONROE TOWNSHIP, NJ NEW YORK, NY 57 57 57
MONROE TOWNSHIP, NJ Total 57 57 57


--
evg1
------------------------------------------------------------------------
evg1's Profile: http://www.excelforum.com/member.php...o&userid=35043
View this thread: http://www.excelforum.com/showthread...hreadid=547887