PivotTable's and PivotMatrix's Map
Mapping fields, headers and data cells
PivotTable::create(array(
...
'map' => array(
'dataField' => function($dataField, $fieldInfo) {
$v = $dataField;
if ($v === 'dollar_sales - sum')
$v = 'Sales (in USD)';
else if ($v === 'dollar_sales - count')
$v = 'Number of Sales';
else if ($v === 'dollar_sales - avg')
$v = 'Sales Average';
return $v;
},
),
...
));
Sales (in USD) | Number of Sales | Sales Average
|
2004
|
2005
|
Total
|
|||||||||||||||||
3
|
4
|
Total
|
1
|
Total
|
||||||||||||||||
AV Stores, Co.
|
Vintage Cars
|
1932 Alfa Romeo 8C2300 Spider Sport
|
-
|
-
|
-
|
$4,602
|
$1
|
$4,602
|
$4,602
|
$1
|
$4,602
|
-
|
-
|
-
|
-
|
-
|
-
|
$4,602
|
$1
|
$4,602
|
1937 Lincoln Berline
|
-
|
-
|
-
|
$4,111
|
$1
|
$4,111
|
$4,111
|
$1
|
$4,111
|
-
|
-
|
-
|
-
|
-
|
-
|
$4,111
|
$1
|
$4,111
|
||
1932 Model A Ford J-Coupe
|
-
|
-
|
-
|
$4,094
|
$1
|
$4,094
|
$4,094
|
$1
|
$4,094
|
-
|
-
|
-
|
-
|
-
|
-
|
$4,094
|
$1
|
$4,094
|
||
18th Century Vintage Horse Carriage
|
-
|
-
|
-
|
$4,021
|
$1
|
$4,021
|
$4,021
|
$1
|
$4,021
|
-
|
-
|
-
|
-
|
-
|
-
|
$4,021
|
$1
|
$4,021
|
||
1903 Ford Model A
|
-
|
-
|
-
|
$3,672
|
$1
|
$3,672
|
$3,672
|
$1
|
$3,672
|
-
|
-
|
-
|
-
|
-
|
-
|
$3,672
|
$1
|
$3,672
|
||
1904 Buick Runabout
|
-
|
-
|
-
|
$3,320
|
$1
|
$3,320
|
$3,320
|
$1
|
$3,320
|
-
|
-
|
-
|
-
|
-
|
-
|
$3,320
|
$1
|
$3,320
|
||
1928 Mercedes-Benz SSK
|
-
|
-
|
-
|
$3,321
|
$1
|
$3,321
|
$3,321
|
$1
|
$3,321
|
-
|
-
|
-
|
-
|
-
|
-
|
$3,321
|
$1
|
$3,321
|
||
1912 Ford Model T Delivery Wagon
|
-
|
-
|
-
|
$2,360
|
$1
|
$2,360
|
$2,360
|
$1
|
$2,360
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,360
|
$1
|
$2,360
|
||
1911 Ford Town Car
|
-
|
-
|
-
|
$2,047
|
$1
|
$2,047
|
$2,047
|
$1
|
$2,047
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,047
|
$1
|
$2,047
|
||
1936 Mercedes Benz 500k Roadster
|
-
|
-
|
-
|
$1,413
|
$1
|
$1,413
|
$1,413
|
$1
|
$1,413
|
-
|
-
|
-
|
-
|
-
|
-
|
$1,413
|
$1
|
$1,413
|
||
1936 Mercedes-Benz 500K Special Roadster
|
-
|
-
|
-
|
$1,383
|
$1
|
$1,383
|
$1,383
|
$1
|
$1,383
|
-
|
-
|
-
|
-
|
-
|
-
|
$1,383
|
$1
|
$1,383
|
||
1934 Ford V8 Coupe
|
-
|
-
|
-
|
$1,380
|
$1
|
$1,380
|
$1,380
|
$1
|
$1,380
|
-
|
-
|
-
|
-
|
-
|
-
|
$1,380
|
$1
|
$1,380
|
||
1939 Chevrolet Deluxe Coupe
|
-
|
-
|
-
|
$1,344
|
$1
|
$1,344
|
$1,344
|
$1
|
$1,344
|
-
|
-
|
-
|
-
|
-
|
-
|
$1,344
|
$1
|
$1,344
|
||
1938 Cadillac V-16 Presidential Limousine
|
-
|
-
|
-
|
$1,118
|
$1
|
$1,118
|
$1,118
|
$1
|
$1,118
|
-
|
-
|
-
|
-
|
-
|
-
|
$1,118
|
$1
|
$1,118
|
||
Total
|
-
|
-
|
-
|
$38,187
|
$14
|
$2,728
|
$38,187
|
$14
|
$2,728
|
-
|
-
|
-
|
-
|
-
|
-
|
$38,187
|
$14
|
$2,728
|
||
Classic Cars
|
2001 Ferrari Enzo
|
-
|
-
|
-
|
$5,669
|
$1
|
$5,669
|
$5,669
|
$1
|
$5,669
|
-
|
-
|
-
|
-
|
-
|
-
|
$5,669
|
$1
|
$5,669
|
|
1969 Corvair Monza
|
-
|
-
|
-
|
$4,931
|
$1
|
$4,931
|
$4,931
|
$1
|
$4,931
|
-
|
-
|
-
|
-
|
-
|
-
|
$4,931
|
$1
|
$4,931
|
||
1952 Citroen-15CV
|
-
|
-
|
-
|
$4,754
|
$1
|
$4,754
|
$4,754
|
$1
|
$4,754
|
-
|
-
|
-
|
-
|
-
|
-
|
$4,754
|
$1
|
$4,754
|
||
1969 Chevrolet Camaro Z28
|
-
|
-
|
-
|
$3,506
|
$1
|
$3,506
|
$3,506
|
$1
|
$3,506
|
-
|
-
|
-
|
-
|
-
|
-
|
$3,506
|
$1
|
$3,506
|
||
1949 Jaguar XK 120
|
-
|
-
|
-
|
$3,296
|
$1
|
$3,296
|
$3,296
|
$1
|
$3,296
|
-
|
-
|
-
|
-
|
-
|
-
|
$3,296
|
$1
|
$3,296
|
||
2002 Chevy Corvette
|
-
|
-
|
-
|
$2,921
|
$1
|
$2,921
|
$2,921
|
$1
|
$2,921
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,921
|
$1
|
$2,921
|
||
1969 Ford Falcon
|
-
|
-
|
-
|
$2,907
|
$1
|
$2,907
|
$2,907
|
$1
|
$2,907
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,907
|
$1
|
$2,907
|
||
1970 Triumph Spitfire
|
-
|
-
|
-
|
$2,907
|
$1
|
$2,907
|
$2,907
|
$1
|
$2,907
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,907
|
$1
|
$2,907
|
||
1957 Ford Thunderbird
|
-
|
-
|
-
|
$1,482
|
$1
|
$1,482
|
$1,482
|
$1
|
$1,482
|
-
|
-
|
-
|
-
|
-
|
-
|
$1,482
|
$1
|
$1,482
|
||
1970 Chevy Chevelle SS 454
|
-
|
-
|
-
|
$1,420
|
$1
|
$1,420
|
$1,420
|
$1
|
$1,420
|
-
|
-
|
-
|
-
|
-
|
-
|
$1,420
|
$1
|
$1,420
|
||
1966 Shelby Cobra 427 S/C
|
-
|
-
|
-
|
$946
|
$1
|
$946
|
$946
|
$1
|
$946
|
-
|
-
|
-
|
-
|
-
|
-
|
$946
|
$1
|
$946
|
||
Total
|
-
|
-
|
-
|
$34,738
|
$11
|
$3,158
|
$34,738
|
$11
|
$3,158
|
-
|
-
|
-
|
-
|
-
|
-
|
$34,738
|
$11
|
$3,158
|
||
Ships
|
The Titanic
|
-
|
-
|
-
|
$3,173
|
$1
|
$3,173
|
$3,173
|
$1
|
$3,173
|
-
|
-
|
-
|
-
|
-
|
-
|
$3,173
|
$1
|
$3,173
|
|
18th century schooner
|
-
|
-
|
-
|
$3,172
|
$1
|
$3,172
|
$3,172
|
$1
|
$3,172
|
-
|
-
|
-
|
-
|
-
|
-
|
$3,172
|
$1
|
$3,172
|
||
The Schooner Bluenose
|
-
|
-
|
-
|
$3,067
|
$1
|
$3,067
|
$3,067
|
$1
|
$3,067
|
-
|
-
|
-
|
-
|
-
|
-
|
$3,067
|
$1
|
$3,067
|
||
The Mayflower
|
-
|
-
|
-
|
$2,798
|
$1
|
$2,798
|
$2,798
|
$1
|
$2,798
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,798
|
$1
|
$2,798
|
||
The USS Constitution Ship
|
-
|
-
|
-
|
$2,673
|
$1
|
$2,673
|
$2,673
|
$1
|
$2,673
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,673
|
$1
|
$2,673
|
||
The Queen Mary
|
-
|
-
|
-
|
$2,622
|
$1
|
$2,622
|
$2,622
|
$1
|
$2,622
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,622
|
$1
|
$2,622
|
||
Pont Yacht
|
-
|
-
|
-
|
$1,682
|
$1
|
$1,682
|
$1,682
|
$1
|
$1,682
|
-
|
-
|
-
|
-
|
-
|
-
|
$1,682
|
$1
|
$1,682
|
||
Total
|
-
|
-
|
-
|
$19,186
|
$7
|
$2,741
|
$19,186
|
$7
|
$2,741
|
-
|
-
|
-
|
-
|
-
|
-
|
$19,186
|
$7
|
$2,741
|
||
Trains
|
Collectable Wooden Train
|
-
|
-
|
-
|
$3,348
|
$1
|
$3,348
|
$3,348
|
$1
|
$3,348
|
-
|
-
|
-
|
-
|
-
|
-
|
$3,348
|
$1
|
$3,348
|
|
1950's Chicago Surface Lines Streetcar
|
-
|
-
|
-
|
$2,773
|
$1
|
$2,773
|
$2,773
|
$1
|
$2,773
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,773
|
$1
|
$2,773
|
||
1962 City of Detroit Streetcar
|
-
|
-
|
-
|
$1,753
|
$1
|
$1,753
|
$1,753
|
$1
|
$1,753
|
-
|
-
|
-
|
-
|
-
|
-
|
$1,753
|
$1
|
$1,753
|
||
Total
|
-
|
-
|
-
|
$7,874
|
$3
|
$2,625
|
$7,874
|
$3
|
$2,625
|
-
|
-
|
-
|
-
|
-
|
-
|
$7,874
|
$3
|
$2,625
|
||
Total
|
-
|
-
|
-
|
$99,984
|
$35
|
$2,857
|
$99,984
|
$35
|
$2,857
|
-
|
-
|
-
|
-
|
-
|
-
|
$99,984
|
$35
|
$2,857
|
||
Amica Models & Co.
|
Vintage Cars
|
1937 Lincoln Berline
|
$4,367
|
$1
|
$4,367
|
-
|
-
|
-
|
$4,367
|
$1
|
$4,367
|
-
|
-
|
-
|
-
|
-
|
-
|
$4,367
|
$1
|
$4,367
|
1917 Grand Touring Sedan
|
$4,199
|
$1
|
$4,199
|
-
|
-
|
-
|
$4,199
|
$1
|
$4,199
|
-
|
-
|
-
|
-
|
-
|
-
|
$4,199
|
$1
|
$4,199
|
||
1932 Model A Ford J-Coupe
|
$4,045
|
$1
|
$4,045
|
-
|
-
|
-
|
$4,045
|
$1
|
$4,045
|
-
|
-
|
-
|
-
|
-
|
-
|
$4,045
|
$1
|
$4,045
|
||
1913 Ford Model T Speedster
|
$3,775
|
$1
|
$3,775
|
-
|
-
|
-
|
$3,775
|
$1
|
$3,775
|
-
|
-
|
-
|
-
|
-
|
-
|
$3,775
|
$1
|
$3,775
|
||
1904 Buick Runabout
|
$3,570
|
$1
|
$3,570
|
-
|
-
|
-
|
$3,570
|
$1
|
$3,570
|
-
|
-
|
-
|
-
|
-
|
-
|
$3,570
|
$1
|
$3,570
|
||
1928 Mercedes-Benz SSK
|
$3,490
|
$1
|
$3,490
|
-
|
-
|
-
|
$3,490
|
$1
|
$3,490
|
-
|
-
|
-
|
-
|
-
|
-
|
$3,490
|
$1
|
$3,490
|
||
1917 Maxwell Touring Car
|
$3,373
|
$1
|
$3,373
|
-
|
-
|
-
|
$3,373
|
$1
|
$3,373
|
-
|
-
|
-
|
-
|
-
|
-
|
$3,373
|
$1
|
$3,373
|
||
18th Century Vintage Horse Carriage
|
$2,976
|
$1
|
$2,976
|
-
|
-
|
-
|
$2,976
|
$1
|
$2,976
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,976
|
$1
|
$2,976
|
||
1932 Alfa Romeo 8C2300 Spider Sport
|
$2,706
|
$1
|
$2,706
|
-
|
-
|
-
|
$2,706
|
$1
|
$2,706
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,706
|
$1
|
$2,706
|
||
1903 Ford Model A
|
$2,655
|
$1
|
$2,655
|
-
|
-
|
-
|
$2,655
|
$1
|
$2,655
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,655
|
$1
|
$2,655
|
||
1934 Ford V8 Coupe
|
$2,337
|
$1
|
$2,337
|
-
|
-
|
-
|
$2,337
|
$1
|
$2,337
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,337
|
$1
|
$2,337
|
||
1936 Chrysler Airflow
|
$1,677
|
$1
|
$1,677
|
-
|
-
|
-
|
$1,677
|
$1
|
$1,677
|
-
|
-
|
-
|
-
|
-
|
-
|
$1,677
|
$1
|
$1,677
|
||
1938 Cadillac V-16 Presidential Limousine
|
$1,633
|
$1
|
$1,633
|
-
|
-
|
-
|
$1,633
|
$1
|
$1,633
|
-
|
-
|
-
|
-
|
-
|
-
|
$1,633
|
$1
|
$1,633
|
||
1911 Ford Town Car
|
$1,332
|
$1
|
$1,332
|
-
|
-
|
-
|
$1,332
|
$1
|
$1,332
|
-
|
-
|
-
|
-
|
-
|
-
|
$1,332
|
$1
|
$1,332
|
||
1936 Mercedes-Benz 500K Special Roadster
|
$1,281
|
$1
|
$1,281
|
-
|
-
|
-
|
$1,281
|
$1
|
$1,281
|
-
|
-
|
-
|
-
|
-
|
-
|
$1,281
|
$1
|
$1,281
|
||
1936 Mercedes Benz 500k Roadster
|
$1,165
|
$1
|
$1,165
|
-
|
-
|
-
|
$1,165
|
$1
|
$1,165
|
-
|
-
|
-
|
-
|
-
|
-
|
$1,165
|
$1
|
$1,165
|
||
1939 Chevrolet Deluxe Coupe
|
$597
|
$1
|
$597
|
-
|
-
|
-
|
$597
|
$1
|
$597
|
-
|
-
|
-
|
-
|
-
|
-
|
$597
|
$1
|
$597
|
||
Total
|
$45,177
|
$17
|
$2,657
|
-
|
-
|
-
|
$45,177
|
$17
|
$2,657
|
-
|
-
|
-
|
-
|
-
|
-
|
$45,177
|
$17
|
$2,657
|
||
Classic Cars
|
2001 Ferrari Enzo
|
$8,603
|
$1
|
$8,603
|
-
|
-
|
-
|
$8,603
|
$1
|
$8,603
|
-
|
-
|
-
|
-
|
-
|
-
|
$8,603
|
$1
|
$8,603
|
|
1969 Ford Falcon
|
$7,708
|
$1
|
$7,708
|
-
|
-
|
-
|
$7,708
|
$1
|
$7,708
|
-
|
-
|
-
|
-
|
-
|
-
|
$7,708
|
$1
|
$7,708
|
||
1952 Alpine Renault 1300
|
$6,995
|
$1
|
$6,995
|
-
|
-
|
-
|
$6,995
|
$1
|
$6,995
|
-
|
-
|
-
|
-
|
-
|
-
|
$6,995
|
$1
|
$6,995
|
||
1969 Corvair Monza
|
$3,118
|
$1
|
$3,118
|
-
|
-
|
-
|
$3,118
|
$1
|
$3,118
|
-
|
-
|
-
|
-
|
-
|
-
|
$3,118
|
$1
|
$3,118
|
||
Total
|
$26,424
|
$4
|
$6,606
|
-
|
-
|
-
|
$26,424
|
$4
|
$6,606
|
-
|
-
|
-
|
-
|
-
|
-
|
$26,424
|
$4
|
$6,606
|
||
Ships
|
18th century schooner
|
$2,348
|
$1
|
$2,348
|
-
|
-
|
-
|
$2,348
|
$1
|
$2,348
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,348
|
$1
|
$2,348
|
|
The Mayflower
|
$2,261
|
$1
|
$2,261
|
-
|
-
|
-
|
$2,261
|
$1
|
$2,261
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,261
|
$1
|
$2,261
|
||
Pont Yacht
|
$1,642
|
$1
|
$1,642
|
-
|
-
|
-
|
$1,642
|
$1
|
$1,642
|
-
|
-
|
-
|
-
|
-
|
-
|
$1,642
|
$1
|
$1,642
|
||
Total
|
$6,251
|
$3
|
$2,084
|
-
|
-
|
-
|
$6,251
|
$3
|
$2,084
|
-
|
-
|
-
|
-
|
-
|
-
|
$6,251
|
$3
|
$2,084
|
||
Trucks and Buses
|
1940 Ford Pickup Truck
|
$2,352
|
$1
|
$2,352
|
-
|
-
|
-
|
$2,352
|
$1
|
$2,352
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,352
|
$1
|
$2,352
|
|
Total
|
$2,352
|
$1
|
$2,352
|
-
|
-
|
-
|
$2,352
|
$1
|
$2,352
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,352
|
$1
|
$2,352
|
||
Trains
|
Collectable Wooden Train
|
$2,019
|
$1
|
$2,019
|
-
|
-
|
-
|
$2,019
|
$1
|
$2,019
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,019
|
$1
|
$2,019
|
|
Total
|
$2,019
|
$1
|
$2,019
|
-
|
-
|
-
|
$2,019
|
$1
|
$2,019
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,019
|
$1
|
$2,019
|
||
Total
|
$82,223
|
$26
|
$3,162
|
-
|
-
|
-
|
$82,223
|
$26
|
$3,162
|
-
|
-
|
-
|
-
|
-
|
-
|
$82,223
|
$26
|
$3,162
|
||
Anna's Decorations, Ltd
|
Trucks and Buses
|
1958 Setra Bus
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
$10,612
|
$2
|
$5,306
|
$10,612
|
$2
|
$5,306
|
$10,612
|
$2
|
$5,306
|
1940 Ford Pickup Truck
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
$6,025
|
$2
|
$3,013
|
$6,025
|
$2
|
$3,013
|
$6,025
|
$2
|
$3,013
|
||
1926 Ford Fire Engine
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
$3,864
|
$2
|
$1,932
|
$3,864
|
$2
|
$1,932
|
$3,864
|
$2
|
$1,932
|
||
1940s Ford truck
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
$3,055
|
$1
|
$3,055
|
$3,055
|
$1
|
$3,055
|
$3,055
|
$1
|
$3,055
|
||
1964 Mercedes Tour Bus
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,241
|
$1 |