PivotTable's and PivotMatrix's multiple options
Options for hiding subtotal rows and columns, showing data headers, mapping fields, headers and data cells
PivotTable::create(array(
...
'hideSubtotalRow' => true,
'hideSubtotalColumn' => true,
'showDataHeaders' => true,
...
));
dollar_sales - sum | dollar_sales - count
|
2004
|
2005
|
Total
|
|||||||||||
3
|
4
|
Total
|
1
|
Total
|
||||||||||
dollar_sales - sum
|
dollar_sales - count
|
dollar_sales - sum
|
dollar_sales - count
|
dollar_sales - sum
|
dollar_sales - count
|
dollar_sales - sum
|
dollar_sales - count
|
dollar_sales - sum
|
dollar_sales - count
|
dollar_sales - sum
|
dollar_sales - count
|
|||
AV Stores, Co.
|
Vintage Cars
|
1932 Alfa Romeo 8C2300 Spider Sport
|
-
|
-
|
$4,602
|
$1
|
$4,602
|
$1
|
-
|
-
|
-
|
-
|
$4,602
|
$1
|
1937 Lincoln Berline
|
-
|
-
|
$4,111
|
$1
|
$4,111
|
$1
|
-
|
-
|
-
|
-
|
$4,111
|
$1
|
||
1932 Model A Ford J-Coupe
|
-
|
-
|
$4,094
|
$1
|
$4,094
|
$1
|
-
|
-
|
-
|
-
|
$4,094
|
$1
|
||
18th Century Vintage Horse Carriage
|
-
|
-
|
$4,021
|
$1
|
$4,021
|
$1
|
-
|
-
|
-
|
-
|
$4,021
|
$1
|
||
1903 Ford Model A
|
-
|
-
|
$3,672
|
$1
|
$3,672
|
$1
|
-
|
-
|
-
|
-
|
$3,672
|
$1
|
||
1904 Buick Runabout
|
-
|
-
|
$3,320
|
$1
|
$3,320
|
$1
|
-
|
-
|
-
|
-
|
$3,320
|
$1
|
||
1928 Mercedes-Benz SSK
|
-
|
-
|
$3,321
|
$1
|
$3,321
|
$1
|
-
|
-
|
-
|
-
|
$3,321
|
$1
|
||
1912 Ford Model T Delivery Wagon
|
-
|
-
|
$2,360
|
$1
|
$2,360
|
$1
|
-
|
-
|
-
|
-
|
$2,360
|
$1
|
||
1911 Ford Town Car
|
-
|
-
|
$2,047
|
$1
|
$2,047
|
$1
|
-
|
-
|
-
|
-
|
$2,047
|
$1
|
||
1936 Mercedes Benz 500k Roadster
|
-
|
-
|
$1,413
|
$1
|
$1,413
|
$1
|
-
|
-
|
-
|
-
|
$1,413
|
$1
|
||
1936 Mercedes-Benz 500K Special Roadster
|
-
|
-
|
$1,383
|
$1
|
$1,383
|
$1
|
-
|
-
|
-
|
-
|
$1,383
|
$1
|
||
1934 Ford V8 Coupe
|
-
|
-
|
$1,380
|
$1
|
$1,380
|
$1
|
-
|
-
|
-
|
-
|
$1,380
|
$1
|
||
1939 Chevrolet Deluxe Coupe
|
-
|
-
|
$1,344
|
$1
|
$1,344
|
$1
|
-
|
-
|
-
|
-
|
$1,344
|
$1
|
||
1938 Cadillac V-16 Presidential Limousine
|
-
|
-
|
$1,118
|
$1
|
$1,118
|
$1
|
-
|
-
|
-
|
-
|
$1,118
|
$1
|
||
Total
|
-
|
-
|
$38,187
|
$14
|
$38,187
|
$14
|
-
|
-
|
-
|
-
|
$38,187
|
$14
|
||
Classic Cars
|
2001 Ferrari Enzo
|
-
|
-
|
$5,669
|
$1
|
$5,669
|
$1
|
-
|
-
|
-
|
-
|
$5,669
|
$1
|
|
1969 Corvair Monza
|
-
|
-
|
$4,931
|
$1
|
$4,931
|
$1
|
-
|
-
|
-
|
-
|
$4,931
|
$1
|
||
1952 Citroen-15CV
|
-
|
-
|
$4,754
|
$1
|
$4,754
|
$1
|
-
|
-
|
-
|
-
|
$4,754
|
$1
|
||
1969 Chevrolet Camaro Z28
|
-
|
-
|
$3,506
|
$1
|
$3,506
|
$1
|
-
|
-
|
-
|
-
|
$3,506
|
$1
|
||
1949 Jaguar XK 120
|
-
|
-
|
$3,296
|
$1
|
$3,296
|
$1
|
-
|
-
|
-
|
-
|
$3,296
|
$1
|
||
2002 Chevy Corvette
|
-
|
-
|
$2,921
|
$1
|
$2,921
|
$1
|
-
|
-
|
-
|
-
|
$2,921
|
$1
|
||
1969 Ford Falcon
|
-
|
-
|
$2,907
|
$1
|
$2,907
|
$1
|
-
|
-
|
-
|
-
|
$2,907
|
$1
|
||
1970 Triumph Spitfire
|
-
|
-
|
$2,907
|
$1
|
$2,907
|
$1
|
-
|
-
|
-
|
-
|
$2,907
|
$1
|
||
1957 Ford Thunderbird
|
-
|
-
|
$1,482
|
$1
|
$1,482
|
$1
|
-
|
-
|
-
|
-
|
$1,482
|
$1
|
||
1970 Chevy Chevelle SS 454
|
-
|
-
|
$1,420
|
$1
|
$1,420
|
$1
|
-
|
-
|
-
|
-
|
$1,420
|
$1
|
||
1966 Shelby Cobra 427 S/C
|
-
|
-
|
$946
|
$1
|
$946
|
$1
|
-
|
-
|
-
|
-
|
$946
|
$1
|
||
Total
|
-
|
-
|
$34,738
|
$11
|
$34,738
|
$11
|
-
|
-
|
-
|
-
|
$34,738
|
$11
|
||
Ships
|
The Titanic
|
-
|
-
|
$3,173
|
$1
|
$3,173
|
$1
|
-
|
-
|
-
|
-
|
$3,173
|
$1
|
|
18th century schooner
|
-
|
-
|
$3,172
|
$1
|
$3,172
|
$1
|
-
|
-
|
-
|
-
|
$3,172
|
$1
|
||
The Schooner Bluenose
|
-
|
-
|
$3,067
|
$1
|
$3,067
|
$1
|
-
|
-
|
-
|
-
|
$3,067
|
$1
|
||
The Mayflower
|
-
|
-
|
$2,798
|
$1
|
$2,798
|
$1
|
-
|
-
|
-
|
-
|
$2,798
|
$1
|
||
The USS Constitution Ship
|
-
|
-
|
$2,673
|
$1
|
$2,673
|
$1
|
-
|
-
|
-
|
-
|
$2,673
|
$1
|
||
The Queen Mary
|
-
|
-
|
$2,622
|
$1
|
$2,622
|
$1
|
-
|
-
|
-
|
-
|
$2,622
|
$1
|
||
Pont Yacht
|
-
|
-
|
$1,682
|
$1
|
$1,682
|
$1
|
-
|
-
|
-
|
-
|
$1,682
|
$1
|
||
Total
|
-
|
-
|
$19,186
|
$7
|
$19,186
|
$7
|
-
|
-
|
-
|
-
|
$19,186
|
$7
|
||
Trains
|
Collectable Wooden Train
|
-
|
-
|
$3,348
|
$1
|
$3,348
|
$1
|
-
|
-
|
-
|
-
|
$3,348
|
$1
|
|
1950's Chicago Surface Lines Streetcar
|
-
|
-
|
$2,773
|
$1
|
$2,773
|
$1
|
-
|
-
|
-
|
-
|
$2,773
|
$1
|
||
1962 City of Detroit Streetcar
|
-
|
-
|
$1,753
|
$1
|
$1,753
|
$1
|
-
|
-
|
-
|
-
|
$1,753
|
$1
|
||
Total
|
-
|
-
|
$7,874
|
$3
|
$7,874
|
$3
|
-
|
-
|
-
|
-
|
$7,874
|
$3
|
||
Total
|
-
|
-
|
$99,984
|
$35
|
$99,984
|
$35
|
-
|
-
|
-
|
-
|
$99,984
|
$35
|
||
Amica Models & Co.
|
Vintage Cars
|
1937 Lincoln Berline
|
$4,367
|
$1
|
-
|
-
|
$4,367
|
$1
|
-
|
-
|
-
|
-
|
$4,367
|
$1
|
1917 Grand Touring Sedan
|
$4,199
|
$1
|
-
|
-
|
$4,199
|
$1
|
-
|
-
|
-
|
-
|
$4,199
|
$1
|
||
1932 Model A Ford J-Coupe
|
$4,045
|
$1
|
-
|
-
|
$4,045
|
$1
|
-
|
-
|
-
|
-
|
$4,045
|
$1
|
||
1913 Ford Model T Speedster
|
$3,775
|
$1
|
-
|
-
|
$3,775
|
$1
|
-
|
-
|
-
|
-
|
$3,775
|
$1
|
||
1904 Buick Runabout
|
$3,570
|
$1
|
-
|
-
|
$3,570
|
$1
|
-
|
-
|
-
|
-
|
$3,570
|
$1
|
||
1928 Mercedes-Benz SSK
|
$3,490
|
$1
|
-
|
-
|
$3,490
|
$1
|
-
|
-
|
-
|
-
|
$3,490
|
$1
|
||
1917 Maxwell Touring Car
|
$3,373
|
$1
|
-
|
-
|
$3,373
|
$1
|
-
|
-
|
-
|
-
|
$3,373
|
$1
|
||
18th Century Vintage Horse Carriage
|
$2,976
|
$1
|
-
|
-
|
$2,976
|
$1
|
-
|
-
|
-
|
-
|
$2,976
|
$1
|
||
1932 Alfa Romeo 8C2300 Spider Sport
|
$2,706
|
$1
|
-
|
-
|
$2,706
|
$1
|
-
|
-
|
-
|
-
|
$2,706
|
$1
|
||
1903 Ford Model A
|
$2,655
|
$1
|
-
|
-
|
$2,655
|
$1
|
-
|
-
|
-
|
-
|
$2,655
|
$1
|
||
1934 Ford V8 Coupe
|
$2,337
|
$1
|
-
|
-
|
$2,337
|
$1
|
-
|
-
|
-
|
-
|
$2,337
|
$1
|
||
1936 Chrysler Airflow
|
$1,677
|
$1
|
-
|
-
|
$1,677
|
$1
|
-
|
-
|
-
|
-
|
$1,677
|
$1
|
||
1938 Cadillac V-16 Presidential Limousine
|
$1,633
|
$1
|
-
|
-
|
$1,633
|
$1
|
-
|
-
|
-
|
-
|
$1,633
|
$1
|
||
1911 Ford Town Car
|
$1,332
|
$1
|
-
|
-
|
$1,332
|
$1
|
-
|
-
|
-
|
-
|
$1,332
|
$1
|
||
1936 Mercedes-Benz 500K Special Roadster
|
$1,281
|
$1
|
-
|
-
|
$1,281
|
$1
|
-
|
-
|
-
|
-
|
$1,281
|
$1
|
||
1936 Mercedes Benz 500k Roadster
|
$1,165
|
$1
|
-
|
-
|
$1,165
|
$1
|
-
|
-
|
-
|
-
|
$1,165
|
$1
|
||
1939 Chevrolet Deluxe Coupe
|
$597
|
$1
|
-
|
-
|
$597
|
$1
|
-
|
-
|
-
|
-
|
$597
|
$1
|
||
Total
|
$45,177
|
$17
|
-
|
-
|
$45,177
|
$17
|
-
|
-
|
-
|
-
|
$45,177
|
$17
|
||
Classic Cars
|
2001 Ferrari Enzo
|
$8,603
|
$1
|
-
|
-
|
$8,603
|
$1
|
-
|
-
|
-
|
-
|
$8,603
|
$1
|
|
1969 Ford Falcon
|
$7,708
|
$1
|
-
|
-
|
$7,708
|
$1
|
-
|
-
|
-
|
-
|
$7,708
|
$1
|
||
1952 Alpine Renault 1300
|
$6,995
|
$1
|
-
|
-
|
$6,995
|
$1
|
-
|
-
|
-
|
-
|
$6,995
|
$1
|
||
1969 Corvair Monza
|
$3,118
|
$1
|
-
|
-
|
$3,118
|
$1
|
-
|
-
|
-
|
-
|
$3,118
|
$1
|
||
Total
|
$26,424
|
$4
|
-
|
-
|
$26,424
|
$4
|
-
|
-
|
-
|
-
|
$26,424
|
$4
|
||
Ships
|
18th century schooner
|
$2,348
|
$1
|
-
|
-
|
$2,348
|
$1
|
-
|
-
|
-
|
-
|
$2,348
|
$1
|
|
The Mayflower
|
$2,261
|
$1
|
-
|
-
|
$2,261
|
$1
|
-
|
-
|
-
|
-
|
$2,261
|
$1
|
||
Pont Yacht
|
$1,642
|
$1
|
-
|
-
|
$1,642
|
$1
|
-
|
-
|
-
|
-
|
$1,642
|
$1
|
||
Total
|
$6,251
|
$3
|
-
|
-
|
$6,251
|
$3
|
-
|
-
|
-
|
-
|
$6,251
|
$3
|
||
Trucks and Buses
|
1940 Ford Pickup Truck
|
$2,352
|
$1
|
-
|
-
|
$2,352
|
$1
|
-
|
-
|
-
|
-
|
$2,352
|
$1
|
|
Total
|
$2,352
|
$1
|
-
|
-
|
$2,352
|
$1
|
-
|
-
|
-
|
-
|
$2,352
|
$1
|
||
Trains
|
Collectable Wooden Train
|
$2,019
|
$1
|
-
|
-
|
$2,019
|
$1
|
-
|
-
|
-
|
-
|
$2,019
|
$1
|
|
Total
|
$2,019
|
$1
|
-
|
-
|
$2,019
|
$1
|
-
|
-
|
-
|
-
|
$2,019
|
$1
|
||
Total
|
$82,223
|
$26
|
-
|
-
|
$82,223
|
$26
|
-
|
-
|
-
|
-
|
$82,223
|
$26
|
||
Anna's Decorations, Ltd
|
Trucks and Buses
|
1958 Setra Bus
|
-
|
-
|
-
|
-
|
-
|
-
|
$10,612
|
$2
|
$10,612
|
$2
|
$10,612
|
$2
|
1940 Ford Pickup Truck
|
-
|
-
|
-
|
-
|
-
|
-
|
$6,025
|
$2
|
$6,025
|
$2
|
$6,025
|
$2
|
||
1926 Ford Fire Engine
|
-
|
-
|
-
|
-
|
-
|
-
|
$3,864
|
$2
|
$3,864
|
$2
|
$3,864
|
$2
|
||
1940s Ford truck
|
-
|
-
|
-
|
-
|
-
|
-
|
$3,055
|
$1
|
$3,055
|
$1
|
$3,055
|
$1
|
||
1964 Mercedes Tour Bus
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,241
|
$1
|
$2,241
|
$1
|
$2,241
|
$1
|
||
1996 Peterbilt 379 Stake Bed with Outrigger
|
-
|
-
|
-
|
-
|
-
|
-
|
$1,600
|
$1
|
$1,600
|
$1
|
$1,600
|
$1
|
||
Total
|
-
|
-
|
-
|
-
|
-
|
-
|
$27,397
|
$9
|
$27,397
|
$9
|
$27,397
|
$9
|
||
Classic Cars
|
1962 LanciaA Delta 16V
|
-
|
-
|
-
|
-
|
-
|
-
|
$8,981
|
$2
|
$8,981
|
$2
|
$8,981
|
$2
|
|
1952 Alpine Renault 1300
|
-
|
-
|
-
|
-
|
-
|
-
|
$4,680
|
$1
|
$4,680
|
$1
|
$4,680
|
$1
|
||
1992 Ferrari 360 Spider red
|
-
|
-
|
-
|
-
|
-
|
-
|
$4,527
|
$1
|
$4,527
|
$1
|
$4,527
|
$1
|
||
Total
|
-
|
-
|
-
|
-
|
-
|
-
|
$18,188
|
$4
|
$18,188
|
$4
|
$18,188
|
$4
|
||
Vintage Cars
|
1937 Lincoln Berline
|
-
|
-
|
-
|
-
|
-
|
-
|
$3,596
|
$1
|
$3,596
|
$1
|
$3,596
|
$1
|
|
1913 Ford Model T Speedster
|
-
|
-
|
-
|
-
|
-
|
-
|
$3,177
|
$1
|
$3,177
|
$1
|
$3,177
|
$1
|
||
1936 Mercedes-Benz 500K Special Roadster
|
-
|
-
|
-
|
-
|
-
|
-
|
$1,992
|
$1
|
$1,992
|
$1
|
$1,992
|
$1
|
||
1939 Chevrolet Deluxe Coupe
|
-
|
-
|
-
|
-
|
-
|
-
|
$876
|
$1
|
$876
|
$1
|
$876
|
$1
|
||
1938 Cadillac V-16 Presidential Limousine
|
-
|
-
|
-
|
-
|
-
|
-
|
$871
|
$1
|
$871
|
$1
|
$871
|
$1
|
||
1939 Cadillac Limousine
|
-
|
-
|
-
|
-
|
-
|
-
|
$835
|
$1
|
$835
|
$1
|
$835
|
$1
|
||
Total
|
-
|
-
|
-
|
-
|
-
|
-
|
$11,348
|
$6
|
$11,348
|
$6
|
$11,348
|
$6
|
||
Total
|
-
|
-
|
-
|
-
|
-
|
-
|
$56,932
|
$19
|
$56,932
|
$19
|
$56,932
|
$19
|
||
Alpha Cognac
|
Ships
|
The Titanic
|
-
|
-
|
-
|
-
|
-
|
-
|
$4,135
|
$1
|
$4,135
|
$1
|
$4,135
|
$1
|
The Queen Mary
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,896
|
$1
|
$2,896
|
$1
|
$2,896
|
$1
|
||
The Mayflower
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,217
|
$1
|
$2,217
|
$1
|
$2,217
|
$1
|
||
Pont Yacht
|
-
|
-
|
-
|
-
|
-
|
-
|
$1,801
|
$1
|
$1,801
|
$1
|
$1,801
|
$1
|
||
The USS Constitution Ship
|
-
|
-
|
-
|
-
|
-
|
-
|
$1,383
|
$1
|
$1,383
|
$1
|
$1,383
|
$1
|
||
Total
|
-
|
-
|
-
|
-
|
-
|
-
|
$12,432
|
$5
|
$12,432
|
$5
|
$12,432
|
$5
|
||
Total
|
-
|
-
|
-
|
-
|
-
|
-
|
$12,432
|
$5
|
$12,432
|
$5
|
$12,432
|
$5
|
||
Atelier graphique
|
Motorcycles
|
1996 Moto Guzzi 1100i
|
$4,129
|
$1
|
-
|
-
|
$4,129
|
$1
|
-
|
-
|
-
|
-
|
$4,129
|
$1
|
1936 Harley Davidson El Knucklehead
|
$1,938
|
$1
|
-
|
-
|
$1,938
|
$1
|
-
|
-
|
-
|
-
|
$1,938
|
$1
|
||
Total
|
$6,067
|
$2
|
-
|
-
|
$6,067
|
$2
|