PivotTable's and PivotMatrix's Field Order
Adding order number to row and column headers
PivotTable::create(array(
...
'map' => array(
'rowHeader' => function($rowHeader, $headerInfo) {
$v = $rowHeader;
if (isset($headerInfo['childOrder']))
$v = $headerInfo['childOrder'] . ". " . $v;
return $v;
},
'columnHeader' => function($colHeader, $headerInfo) {
$v = $colHeader;
if (isset($headerInfo['childOrder']))
$v = $headerInfo['childOrder'] . ". " . $v;
return $v;
},
),
...
));
dollar_sales - sum | dollar_sales - count | dollar_sales - avg
|
1. Year-2004
|
2. Year-2005
|
Total
|
|||||||||||||||||
1.1. Quarter-3
|
1.2. Quarter-4
|
Total
|
2.1. Quarter-1
|
Total
|
||||||||||||||||
1. AV Stores, Co.
|
1.1. Vintage Cars
|
1.1.1. 1932 Alfa Romeo 8C2300 Spider Sport
|
-
|
-
|
-
|
$4,602
|
$1
|
$4,602
|
$4,602
|
$1
|
$4,602
|
-
|
-
|
-
|
-
|
-
|
-
|
$4,602
|
$1
|
$4,602
|
1.1.2. 1937 Lincoln Berline
|
-
|
-
|
-
|
$4,111
|
$1
|
$4,111
|
$4,111
|
$1
|
$4,111
|
-
|
-
|
-
|
-
|
-
|
-
|
$4,111
|
$1
|
$4,111
|
||
1.1.3. 1932 Model A Ford J-Coupe
|
-
|
-
|
-
|
$4,094
|
$1
|
$4,094
|
$4,094
|
$1
|
$4,094
|
-
|
-
|
-
|
-
|
-
|
-
|
$4,094
|
$1
|
$4,094
|
||
1.1.4. 18th Century Vintage Horse Carriage
|
-
|
-
|
-
|
$4,021
|
$1
|
$4,021
|
$4,021
|
$1
|
$4,021
|
-
|
-
|
-
|
-
|
-
|
-
|
$4,021
|
$1
|
$4,021
|
||
1.1.5. 1903 Ford Model A
|
-
|
-
|
-
|
$3,672
|
$1
|
$3,672
|
$3,672
|
$1
|
$3,672
|
-
|
-
|
-
|
-
|
-
|
-
|
$3,672
|
$1
|
$3,672
|
||
1.1.6. 1904 Buick Runabout
|
-
|
-
|
-
|
$3,320
|
$1
|
$3,320
|
$3,320
|
$1
|
$3,320
|
-
|
-
|
-
|
-
|
-
|
-
|
$3,320
|
$1
|
$3,320
|
||
1.1.7. 1928 Mercedes-Benz SSK
|
-
|
-
|
-
|
$3,321
|
$1
|
$3,321
|
$3,321
|
$1
|
$3,321
|
-
|
-
|
-
|
-
|
-
|
-
|
$3,321
|
$1
|
$3,321
|
||
1.1.8. 1912 Ford Model T Delivery Wagon
|
-
|
-
|
-
|
$2,360
|
$1
|
$2,360
|
$2,360
|
$1
|
$2,360
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,360
|
$1
|
$2,360
|
||
1.1.9. 1911 Ford Town Car
|
-
|
-
|
-
|
$2,047
|
$1
|
$2,047
|
$2,047
|
$1
|
$2,047
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,047
|
$1
|
$2,047
|
||
1.1.10. 1936 Mercedes Benz 500k Roadster
|
-
|
-
|
-
|
$1,413
|
$1
|
$1,413
|
$1,413
|
$1
|
$1,413
|
-
|
-
|
-
|
-
|
-
|
-
|
$1,413
|
$1
|
$1,413
|
||
1.1.11. 1936 Mercedes-Benz 500K Special Roadster
|
-
|
-
|
-
|
$1,383
|
$1
|
$1,383
|
$1,383
|
$1
|
$1,383
|
-
|
-
|
-
|
-
|
-
|
-
|
$1,383
|
$1
|
$1,383
|
||
1.1.12. 1934 Ford V8 Coupe
|
-
|
-
|
-
|
$1,380
|
$1
|
$1,380
|
$1,380
|
$1
|
$1,380
|
-
|
-
|
-
|
-
|
-
|
-
|
$1,380
|
$1
|
$1,380
|
||
1.1.13. 1939 Chevrolet Deluxe Coupe
|
-
|
-
|
-
|
$1,344
|
$1
|
$1,344
|
$1,344
|
$1
|
$1,344
|
-
|
-
|
-
|
-
|
-
|
-
|
$1,344
|
$1
|
$1,344
|
||
1.1.14. 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
|
||
1.2. Classic Cars
|
1.2.1. 2001 Ferrari Enzo
|
-
|
-
|
-
|
$5,669
|
$1
|
$5,669
|
$5,669
|
$1
|
$5,669
|
-
|
-
|
-
|
-
|
-
|
-
|
$5,669
|
$1
|
$5,669
|
|
1.2.2. 1969 Corvair Monza
|
-
|
-
|
-
|
$4,931
|
$1
|
$4,931
|
$4,931
|
$1
|
$4,931
|
-
|
-
|
-
|
-
|
-
|
-
|
$4,931
|
$1
|
$4,931
|
||
1.2.3. 1952 Citroen-15CV
|
-
|
-
|
-
|
$4,754
|
$1
|
$4,754
|
$4,754
|
$1
|
$4,754
|
-
|
-
|
-
|
-
|
-
|
-
|
$4,754
|
$1
|
$4,754
|
||
1.2.4. 1969 Chevrolet Camaro Z28
|
-
|
-
|
-
|
$3,506
|
$1
|
$3,506
|
$3,506
|
$1
|
$3,506
|
-
|
-
|
-
|
-
|
-
|
-
|
$3,506
|
$1
|
$3,506
|
||
1.2.5. 1949 Jaguar XK 120
|
-
|
-
|
-
|
$3,296
|
$1
|
$3,296
|
$3,296
|
$1
|
$3,296
|
-
|
-
|
-
|
-
|
-
|
-
|
$3,296
|
$1
|
$3,296
|
||
1.2.6. 2002 Chevy Corvette
|
-
|
-
|
-
|
$2,921
|
$1
|
$2,921
|
$2,921
|
$1
|
$2,921
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,921
|
$1
|
$2,921
|
||
1.2.7. 1969 Ford Falcon
|
-
|
-
|
-
|
$2,907
|
$1
|
$2,907
|
$2,907
|
$1
|
$2,907
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,907
|
$1
|
$2,907
|
||
1.2.8. 1970 Triumph Spitfire
|
-
|
-
|
-
|
$2,907
|
$1
|
$2,907
|
$2,907
|
$1
|
$2,907
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,907
|
$1
|
$2,907
|
||
1.2.9. 1957 Ford Thunderbird
|
-
|
-
|
-
|
$1,482
|
$1
|
$1,482
|
$1,482
|
$1
|
$1,482
|
-
|
-
|
-
|
-
|
-
|
-
|
$1,482
|
$1
|
$1,482
|
||
1.2.10. 1970 Chevy Chevelle SS 454
|
-
|
-
|
-
|
$1,420
|
$1
|
$1,420
|
$1,420
|
$1
|
$1,420
|
-
|
-
|
-
|
-
|
-
|
-
|
$1,420
|
$1
|
$1,420
|
||
1.2.11. 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
|
||
1.3. Ships
|
1.3.1. The Titanic
|
-
|
-
|
-
|
$3,173
|
$1
|
$3,173
|
$3,173
|
$1
|
$3,173
|
-
|
-
|
-
|
-
|
-
|
-
|
$3,173
|
$1
|
$3,173
|
|
1.3.2. 18th century schooner
|
-
|
-
|
-
|
$3,172
|
$1
|
$3,172
|
$3,172
|
$1
|
$3,172
|
-
|
-
|
-
|
-
|
-
|
-
|
$3,172
|
$1
|
$3,172
|
||
1.3.3. The Schooner Bluenose
|
-
|
-
|
-
|
$3,067
|
$1
|
$3,067
|
$3,067
|
$1
|
$3,067
|
-
|
-
|
-
|
-
|
-
|
-
|
$3,067
|
$1
|
$3,067
|
||
1.3.4. The Mayflower
|
-
|
-
|
-
|
$2,798
|
$1
|
$2,798
|
$2,798
|
$1
|
$2,798
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,798
|
$1
|
$2,798
|
||
1.3.5. The USS Constitution Ship
|
-
|
-
|
-
|
$2,673
|
$1
|
$2,673
|
$2,673
|
$1
|
$2,673
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,673
|
$1
|
$2,673
|
||
1.3.6. The Queen Mary
|
-
|
-
|
-
|
$2,622
|
$1
|
$2,622
|
$2,622
|
$1
|
$2,622
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,622
|
$1
|
$2,622
|
||
1.3.7. 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
|
||
1.4. Trains
|
1.4.1. Collectable Wooden Train
|
-
|
-
|
-
|
$3,348
|
$1
|
$3,348
|
$3,348
|
$1
|
$3,348
|
-
|
-
|
-
|
-
|
-
|
-
|
$3,348
|
$1
|
$3,348
|
|
1.4.2. 1950's Chicago Surface Lines Streetcar
|
-
|
-
|
-
|
$2,773
|
$1
|
$2,773
|
$2,773
|
$1
|
$2,773
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,773
|
$1
|
$2,773
|
||
1.4.3. 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
|
||
2. Amica Models & Co.
|
2.1. Vintage Cars
|
2.1.1. 1937 Lincoln Berline
|
$4,367
|
$1
|
$4,367
|
-
|
-
|
-
|
$4,367
|
$1
|
$4,367
|
-
|
-
|
-
|
-
|
-
|
-
|
$4,367
|
$1
|
$4,367
|
2.1.2. 1917 Grand Touring Sedan
|
$4,199
|
$1
|
$4,199
|
-
|
-
|
-
|
$4,199
|
$1
|
$4,199
|
-
|
-
|
-
|
-
|
-
|
-
|
$4,199
|
$1
|
$4,199
|
||
2.1.3. 1932 Model A Ford J-Coupe
|
$4,045
|
$1
|
$4,045
|
-
|
-
|
-
|
$4,045
|
$1
|
$4,045
|
-
|
-
|
-
|
-
|
-
|
-
|
$4,045
|
$1
|
$4,045
|
||
2.1.4. 1913 Ford Model T Speedster
|
$3,775
|
$1
|
$3,775
|
-
|
-
|
-
|
$3,775
|
$1
|
$3,775
|
-
|
-
|
-
|
-
|
-
|
-
|
$3,775
|
$1
|
$3,775
|
||
2.1.5. 1904 Buick Runabout
|
$3,570
|
$1
|
$3,570
|
-
|
-
|
-
|
$3,570
|
$1
|
$3,570
|
-
|
-
|
-
|
-
|
-
|
-
|
$3,570
|
$1
|
$3,570
|
||
2.1.6. 1928 Mercedes-Benz SSK
|
$3,490
|
$1
|
$3,490
|
-
|
-
|
-
|
$3,490
|
$1
|
$3,490
|
-
|
-
|
-
|
-
|
-
|
-
|
$3,490
|
$1
|
$3,490
|
||
2.1.7. 1917 Maxwell Touring Car
|
$3,373
|
$1
|
$3,373
|
-
|
-
|
-
|
$3,373
|
$1
|
$3,373
|
-
|
-
|
-
|
-
|
-
|
-
|
$3,373
|
$1
|
$3,373
|
||
2.1.8. 18th Century Vintage Horse Carriage
|
$2,976
|
$1
|
$2,976
|
-
|
-
|
-
|
$2,976
|
$1
|
$2,976
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,976
|
$1
|
$2,976
|
||
2.1.9. 1932 Alfa Romeo 8C2300 Spider Sport
|
$2,706
|
$1
|
$2,706
|
-
|
-
|
-
|
$2,706
|
$1
|
$2,706
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,706
|
$1
|
$2,706
|
||
2.1.10. 1903 Ford Model A
|
$2,655
|
$1
|
$2,655
|
-
|
-
|
-
|
$2,655
|
$1
|
$2,655
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,655
|
$1
|
$2,655
|
||
2.1.11. 1934 Ford V8 Coupe
|
$2,337
|
$1
|
$2,337
|
-
|
-
|
-
|
$2,337
|
$1
|
$2,337
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,337
|
$1
|
$2,337
|
||
2.1.12. 1936 Chrysler Airflow
|
$1,677
|
$1
|
$1,677
|
-
|
-
|
-
|
$1,677
|
$1
|
$1,677
|
-
|
-
|
-
|
-
|
-
|
-
|
$1,677
|
$1
|
$1,677
|
||
2.1.13. 1938 Cadillac V-16 Presidential Limousine
|
$1,633
|
$1
|
$1,633
|
-
|
-
|
-
|
$1,633
|
$1
|
$1,633
|
-
|
-
|
-
|
-
|
-
|
-
|
$1,633
|
$1
|
$1,633
|
||
2.1.14. 1911 Ford Town Car
|
$1,332
|
$1
|
$1,332
|
-
|
-
|
-
|
$1,332
|
$1
|
$1,332
|
-
|
-
|
-
|
-
|
-
|
-
|
$1,332
|
$1
|
$1,332
|
||
2.1.15. 1936 Mercedes-Benz 500K Special Roadster
|
$1,281
|
$1
|
$1,281
|
-
|
-
|
-
|
$1,281
|
$1
|
$1,281
|
-
|
-
|
-
|
-
|
-
|
-
|
$1,281
|
$1
|
$1,281
|
||
2.1.16. 1936 Mercedes Benz 500k Roadster
|
$1,165
|
$1
|
$1,165
|
-
|
-
|
-
|
$1,165
|
$1
|
$1,165
|
-
|
-
|
-
|
-
|
-
|
-
|
$1,165
|
$1
|
$1,165
|
||
2.1.17. 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
|
||
2.2. Classic Cars
|
2.2.1. 2001 Ferrari Enzo
|
$8,603
|
$1
|
$8,603
|
-
|
-
|
-
|
$8,603
|
$1
|
$8,603
|
-
|
-
|
-
|
-
|
-
|
-
|
$8,603
|
$1
|
$8,603
|
|
2.2.2. 1969 Ford Falcon
|
$7,708
|
$1
|
$7,708
|
-
|
-
|
-
|
$7,708
|
$1
|
$7,708
|
-
|
-
|
-
|
-
|
-
|
-
|
$7,708
|
$1
|
$7,708
|
||
2.2.3. 1952 Alpine Renault 1300
|
$6,995
|
$1
|
$6,995
|
-
|
-
|
-
|
$6,995
|
$1
|
$6,995
|
-
|
-
|
-
|
-
|
-
|
-
|
$6,995
|
$1
|
$6,995
|
||
2.2.4. 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
|
||
2.3. Ships
|
2.3.1. 18th century schooner
|
$2,348
|
$1
|
$2,348
|
-
|
-
|
-
|
$2,348
|
$1
|
$2,348
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,348
|
$1
|
$2,348
|
|
2.3.2. The Mayflower
|
$2,261
|
$1
|
$2,261
|
-
|
-
|
-
|
$2,261
|
$1
|
$2,261
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,261
|
$1
|
$2,261
|
||
2.3.3. 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
|
||
2.4. Trucks and Buses
|
2.4.1. 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
|
||
2.5. Trains
|
2.5.1. 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
|
||
3. Anna's Decorations, Ltd
|
3.1. Trucks and Buses
|
3.1.1. 1958 Setra Bus
|
-
|
-
|