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;
},
'rowHeader' => function($rowHeader, $headerInfo) {
return $rowHeader;
},
'columnHeader' => function($colHeader, $headerInfo) {
return $colHeader;
},
'dataCell' => function($value, $cellInfo) {
return $value;
},
),
...
));
dollar_sales - sum | dollar_sales - count | dollar_sales - avg |
2004
|
2005
|
Total
|
|||||||||||||||||
3
|
4
|
Total
|
1
|
Total
|
||||||||||||||||
AV Stores, Co.
|
Vintage Cars
|
1932 Alfa Romeo 8C2300 Spider Sport
|
-
|
-
|
-
|
4601.5
|
1
|
4601.5
|
4601.5
|
1
|
4601.5
|
-
|
-
|
-
|
-
|
-
|
-
|
4601.5
|
1
|
4601.5
|
1937 Lincoln Berline
|
-
|
-
|
-
|
4111.48
|
1
|
4111.48
|
4111.48
|
1
|
4111.48
|
-
|
-
|
-
|
-
|
-
|
-
|
4111.48
|
1
|
4111.48
|
||
1932 Model A Ford J-Coupe
|
-
|
-
|
-
|
4093.6
|
1
|
4093.6
|
4093.6
|
1
|
4093.6
|
-
|
-
|
-
|
-
|
-
|
-
|
4093.6
|
1
|
4093.6
|
||
18th Century Vintage Horse Carriage
|
-
|
-
|
-
|
4021.2
|
1
|
4021.2
|
4021.2
|
1
|
4021.2
|
-
|
-
|
-
|
-
|
-
|
-
|
4021.2
|
1
|
4021.2
|
||
1903 Ford Model A
|
-
|
-
|
-
|
3671.68
|
1
|
3671.68
|
3671.68
|
1
|
3671.68
|
-
|
-
|
-
|
-
|
-
|
-
|
3671.68
|
1
|
3671.68
|
||
1928 Mercedes-Benz SSK
|
-
|
-
|
-
|
3321.12
|
1
|
3321.12
|
3321.12
|
1
|
3321.12
|
-
|
-
|
-
|
-
|
-
|
-
|
3321.12
|
1
|
3321.12
|
||
1904 Buick Runabout
|
-
|
-
|
-
|
3320.46
|
1
|
3320.46
|
3320.46
|
1
|
3320.46
|
-
|
-
|
-
|
-
|
-
|
-
|
3320.46
|
1
|
3320.46
|
||
1912 Ford Model T Delivery Wagon
|
-
|
-
|
-
|
2359.72
|
1
|
2359.72
|
2359.72
|
1
|
2359.72
|
-
|
-
|
-
|
-
|
-
|
-
|
2359.72
|
1
|
2359.72
|
||
1911 Ford Town Car
|
-
|
-
|
-
|
2047.44
|
1
|
2047.44
|
2047.44
|
1
|
2047.44
|
-
|
-
|
-
|
-
|
-
|
-
|
2047.44
|
1
|
2047.44
|
||
1936 Mercedes Benz 500k Roadster
|
-
|
-
|
-
|
1413.27
|
1
|
1413.27
|
1413.27
|
1
|
1413.27
|
-
|
-
|
-
|
-
|
-
|
-
|
1413.27
|
1
|
1413.27
|
||
1936 Mercedes-Benz 500K Special Roadster
|
-
|
-
|
-
|
1382.67
|
1
|
1382.67
|
1382.67
|
1
|
1382.67
|
-
|
-
|
-
|
-
|
-
|
-
|
1382.67
|
1
|
1382.67
|
||
1934 Ford V8 Coupe
|
-
|
-
|
-
|
1380.34
|
1
|
1380.34
|
1380.34
|
1
|
1380.34
|
-
|
-
|
-
|
-
|
-
|
-
|
1380.34
|
1
|
1380.34
|
||
1939 Chevrolet Deluxe Coupe
|
-
|
-
|
-
|
1344.15
|
1
|
1344.15
|
1344.15
|
1
|
1344.15
|
-
|
-
|
-
|
-
|
-
|
-
|
1344.15
|
1
|
1344.15
|
||
1938 Cadillac V-16 Presidential Limousine
|
-
|
-
|
-
|
1118.26
|
1
|
1118.26
|
1118.26
|
1
|
1118.26
|
-
|
-
|
-
|
-
|
-
|
-
|
1118.26
|
1
|
1118.26
|
||
Total
|
-
|
-
|
-
|
38186.89
|
14
|
2727.635
|
38186.89
|
14
|
2727.635
|
-
|
-
|
-
|
-
|
-
|
-
|
38186.89
|
14
|
2727.635
|
||
Classic Cars
|
2001 Ferrari Enzo
|
-
|
-
|
-
|
5668.66
|
1
|
5668.66
|
5668.66
|
1
|
5668.66
|
-
|
-
|
-
|
-
|
-
|
-
|
5668.66
|
1
|
5668.66
|
|
1969 Corvair Monza
|
-
|
-
|
-
|
4931.36
|
1
|
4931.36
|
4931.36
|
1
|
4931.36
|
-
|
-
|
-
|
-
|
-
|
-
|
4931.36
|
1
|
4931.36
|
||
1952 Citroen-15CV
|
-
|
-
|
-
|
4753.76
|
1
|
4753.76
|
4753.76
|
1
|
4753.76
|
-
|
-
|
-
|
-
|
-
|
-
|
4753.76
|
1
|
4753.76
|
||
1969 Chevrolet Camaro Z28
|
-
|
-
|
-
|
3505.95
|
1
|
3505.95
|
3505.95
|
1
|
3505.95
|
-
|
-
|
-
|
-
|
-
|
-
|
3505.95
|
1
|
3505.95
|
||
1949 Jaguar XK 120
|
-
|
-
|
-
|
3295.89
|
1
|
3295.89
|
3295.89
|
1
|
3295.89
|
-
|
-
|
-
|
-
|
-
|
-
|
3295.89
|
1
|
3295.89
|
||
2002 Chevy Corvette
|
-
|
-
|
-
|
2921.13
|
1
|
2921.13
|
2921.13
|
1
|
2921.13
|
-
|
-
|
-
|
-
|
-
|
-
|
2921.13
|
1
|
2921.13
|
||
1969 Ford Falcon
|
-
|
-
|
-
|
2906.8
|
1
|
2906.8
|
2906.8
|
1
|
2906.8
|
-
|
-
|
-
|
-
|
-
|
-
|
2906.8
|
1
|
2906.8
|
||
1970 Triumph Spitfire
|
-
|
-
|
-
|
2906.97
|
1
|
2906.97
|
2906.97
|
1
|
2906.97
|
-
|
-
|
-
|
-
|
-
|
-
|
2906.97
|
1
|
2906.97
|
||
1957 Ford Thunderbird
|
-
|
-
|
-
|
1481.76
|
1
|
1481.76
|
1481.76
|
1
|
1481.76
|
-
|
-
|
-
|
-
|
-
|
-
|
1481.76
|
1
|
1481.76
|
||
1970 Chevy Chevelle SS 454
|
-
|
-
|
-
|
1419.79
|
1
|
1419.79
|
1419.79
|
1
|
1419.79
|
-
|
-
|
-
|
-
|
-
|
-
|
1419.79
|
1
|
1419.79
|
||
1966 Shelby Cobra 427 S/C
|
-
|
-
|
-
|
945.8
|
1
|
945.8
|
945.8
|
1
|
945.8
|
-
|
-
|
-
|
-
|
-
|
-
|
945.8
|
1
|
945.8
|
||
Total
|
-
|
-
|
-
|
34737.87
|
11
|
3157.9881818182
|
34737.87
|
11
|
3157.9881818182
|
-
|
-
|
-
|
-
|
-
|
-
|
34737.87
|
11
|
3157.9881818182
|
||
Ships
|
The Titanic
|
-
|
-
|
-
|
3173.44
|
1
|
3173.44
|
3173.44
|
1
|
3173.44
|
-
|
-
|
-
|
-
|
-
|
-
|
3173.44
|
1
|
3173.44
|
|
18th century schooner
|
-
|
-
|
-
|
3171.73
|
1
|
3171.73
|
3171.73
|
1
|
3171.73
|
-
|
-
|
-
|
-
|
-
|
-
|
3171.73
|
1
|
3171.73
|
||
The Schooner Bluenose
|
-
|
-
|
-
|
3067
|
1
|
3067
|
3067
|
1
|
3067
|
-
|
-
|
-
|
-
|
-
|
-
|
3067
|
1
|
3067
|
||
The Mayflower
|
-
|
-
|
-
|
2797.56
|
1
|
2797.56
|
2797.56
|
1
|
2797.56
|
-
|
-
|
-
|
-
|
-
|
-
|
2797.56
|
1
|
2797.56
|
||
The USS Constitution Ship
|
-
|
-
|
-
|
2672.88
|
1
|
2672.88
|
2672.88
|
1
|
2672.88
|
-
|
-
|
-
|
-
|
-
|
-
|
2672.88
|
1
|
2672.88
|
||
The Queen Mary
|
-
|
-
|
-
|
2621.7
|
1
|
2621.7
|
2621.7
|
1
|
2621.7
|
-
|
-
|
-
|
-
|
-
|
-
|
2621.7
|
1
|
2621.7
|
||
Pont Yacht
|
-
|
-
|
-
|
1681.75
|
1
|
1681.75
|
1681.75
|
1
|
1681.75
|
-
|
-
|
-
|
-
|
-
|
-
|
1681.75
|
1
|
1681.75
|
||
Total
|
-
|
-
|
-
|
19186.06
|
7
|
2740.8657142857
|
19186.06
|
7
|
2740.8657142857
|
-
|
-
|
-
|
-
|
-
|
-
|
19186.06
|
7
|
2740.8657142857
|
||
Trains
|
Collectable Wooden Train
|
-
|
-
|
-
|
3348
|
1
|
3348
|
3348
|
1
|
3348
|
-
|
-
|
-
|
-
|
-
|
-
|
3348
|
1
|
3348
|
|
1950's Chicago Surface Lines Streetcar
|
-
|
-
|
-
|
2772.88
|
1
|
2772.88
|
2772.88
|
1
|
2772.88
|
-
|
-
|
-
|
-
|
-
|
-
|
2772.88
|
1
|
2772.88
|
||
1962 City of Detroit Streetcar
|
-
|
-
|
-
|
1752.7
|
1
|
1752.7
|
1752.7
|
1
|
1752.7
|
-
|
-
|
-
|
-
|
-
|
-
|
1752.7
|
1
|
1752.7
|
||
Total
|
-
|
-
|
-
|
7873.58
|
3
|
2624.5266666667
|
7873.58
|
3
|
2624.5266666667
|
-
|
-
|
-
|
-
|
-
|
-
|
7873.58
|
3
|
2624.5266666667
|
||
Total
|
-
|
-
|
-
|
99984.4
|
35
|
2856.6971428571
|
99984.4
|
35
|
2856.6971428571
|
-
|
-
|
-
|
-
|
-
|
-
|
99984.4
|
35
|
2856.6971428571
|
||
Amica Models & Co.
|
Vintage Cars
|
1937 Lincoln Berline
|
4366.5
|
1
|
4366.5
|
-
|
-
|
-
|
4366.5
|
1
|
4366.5
|
-
|
-
|
-
|
-
|
-
|
-
|
4366.5
|
1
|
4366.5
|
1917 Grand Touring Sedan
|
4199
|
1
|
4199
|
-
|
-
|
-
|
4199
|
1
|
4199
|
-
|
-
|
-
|
-
|
-
|
-
|
4199
|
1
|
4199
|
||
1932 Model A Ford J-Coupe
|
4045.21
|
1
|
4045.21
|
-
|
-
|
-
|
4045.21
|
1
|
4045.21
|
-
|
-
|
-
|
-
|
-
|
-
|
4045.21
|
1
|
4045.21
|
||
1913 Ford Model T Speedster
|
3774.76
|
1
|
3774.76
|
-
|
-
|
-
|
3774.76
|
1
|
3774.76
|
-
|
-
|
-
|
-
|
-
|
-
|
3774.76
|
1
|
3774.76
|
||
1904 Buick Runabout
|
3569.65
|
1
|
3569.65
|
-
|
-
|
-
|
3569.65
|
1
|
3569.65
|
-
|
-
|
-
|
-
|
-
|
-
|
3569.65
|
1
|
3569.65
|
||
1928 Mercedes-Benz SSK
|
3489.86
|
1
|
3489.86
|
-
|
-
|
-
|
3489.86
|
1
|
3489.86
|
-
|
-
|
-
|
-
|
-
|
-
|
3489.86
|
1
|
3489.86
|
||
1917 Maxwell Touring Car
|
3373.14
|
1
|
3373.14
|
-
|
-
|
-
|
3373.14
|
1
|
3373.14
|
-
|
-
|
-
|
-
|
-
|
-
|
3373.14
|
1
|
3373.14
|
||
18th Century Vintage Horse Carriage
|
2976.27
|
1
|
2976.27
|
-
|
-
|
-
|
2976.27
|
1
|
2976.27
|
-
|
-
|
-
|
-
|
-
|
-
|
2976.27
|
1
|
2976.27
|
||
1932 Alfa Romeo 8C2300 Spider Sport
|
2705.85
|
1
|
2705.85
|
-
|
-
|
-
|
2705.85
|
1
|
2705.85
|
-
|
-
|
-
|
-
|
-
|
-
|
2705.85
|
1
|
2705.85
|
||
1903 Ford Model A
|
2655.36
|
1
|
2655.36
|
-
|
-
|
-
|
2655.36
|
1
|
2655.36
|
-
|
-
|
-
|
-
|
-
|
-
|
2655.36
|
1
|
2655.36
|
||
1934 Ford V8 Coupe
|
2336.62
|
1
|
2336.62
|
-
|
-
|
-
|
2336.62
|
1
|
2336.62
|
-
|
-
|
-
|
-
|
-
|
-
|
2336.62
|
1
|
2336.62
|
||
1936 Chrysler Airflow
|
1677.06
|
1
|
1677.06
|
-
|
-
|
-
|
1677.06
|
1
|
1677.06
|
-
|
-
|
-
|
-
|
-
|
-
|
1677.06
|
1
|
1677.06
|
||
1938 Cadillac V-16 Presidential Limousine
|
1633.05
|
1
|
1633.05
|
-
|
-
|
-
|
1633.05
|
1
|
1633.05
|
-
|
-
|
-
|
-
|
-
|
-
|
1633.05
|
1
|
1633.05
|
||
1911 Ford Town Car
|
1332
|
1
|
1332
|
-
|
-
|
-
|
1332
|
1
|
1332
|
-
|
-
|
-
|
-
|
-
|
-
|
1332
|
1
|
1332
|
||
1936 Mercedes-Benz 500K Special Roadster
|
1280.88
|
1
|
1280.88
|
-
|
-
|
-
|
1280.88
|
1
|
1280.88
|
-
|
-
|
-
|
-
|
-
|
-
|
1280.88
|
1
|
1280.88
|
||
1936 Mercedes Benz 500k Roadster
|
1164.57
|
1
|
1164.57
|
-
|
-
|
-
|
1164.57
|
1
|
1164.57
|
-
|
-
|
-
|
-
|
-
|
-
|
1164.57
|
1
|
1164.57
|
||
1939 Chevrolet Deluxe Coupe
|
597.4
|
1
|
597.4
|
-
|
-
|
-
|
597.4
|
1
|
597.4
|
-
|
-
|
-
|
-
|
-
|
-
|
597.4
|
1
|
597.4
|
||
Total
|
45177.18
|
17
|
2657.4811764706
|
-
|
-
|
-
|
45177.18
|
17
|
2657.4811764706
|
-
|
-
|
-
|
-
|
-
|
-
|
45177.18
|
17
|
2657.4811764706
|
||
Classic Cars
|
2001 Ferrari Enzo
|
8602.92
|
1
|
8602.92
|
-
|
-
|
-
|
8602.92
|
1
|
8602.92
|
-
|
-
|
-
|
-
|
-
|
-
|
8602.92
|
1
|
8602.92
|
|
1969 Ford Falcon
|
7708.05
|
1
|
7708.05
|
-
|
-
|
-
|
7708.05
|
1
|
7708.05
|
-
|
-
|
-
|
-
|
-
|
-
|
7708.05
|
1
|
7708.05
|
||
1952 Alpine Renault 1300
|
6994.82
|
1
|
6994.82
|
-
|
-
|
-
|
6994.82
|
1
|
6994.82
|
-
|
-
|
-
|
-
|
-
|
-
|
6994.82
|
1
|
6994.82
|
||
1969 Corvair Monza
|
3118.32
|
1
|
3118.32
|
-
|
-
|
-
|
3118.32
|
1
|
3118.32
|
-
|
-
|
-
|
-
|
-
|
-
|
3118.32
|
1
|
3118.32
|
||
Total
|
26424.11
|
4
|
6606.0275
|
-
|
-
|
-
|
26424.11
|
4
|
6606.0275
|
-
|
-
|
-
|
-
|
-
|
-
|
26424.11
|
4
|
6606.0275
|
||
Ships
|
18th century schooner
|
2348.43
|
1
|
2348.43
|
-
|
-
|
-
|
2348.43
|
1
|
2348.43
|
-
|
-
|
-
|
-
|
-
|
-
|
2348.43
|
1
|
2348.43
|
|
The Mayflower
|
2260.55
|
1
|
2260.55
|
-
|
-
|
-
|
2260.55
|
1
|
2260.55
|
-
|
-
|
-
|
-
|
-
|
-
|
2260.55
|
1
|
2260.55
|
||
Pont Yacht
|
1642.24
|
1
|
1642.24
|
-
|
-
|
-
|
1642.24
|
1
|
1642.24
|
-
|
-
|
-
|
-
|
-
|
-
|
1642.24
|
1
|
1642.24
|
||
Total
|
6251.22
|
3
|
2083.74
|
-
|
-
|
-
|
6251.22
|
3
|
2083.74
|
-
|
-
|
-
|
-
|
-
|
-
|
6251.22
|
3
|
2083.74
|
||
Trucks and Buses
|
1940 Ford Pickup Truck
|
2352
|
1
|
2352
|
-
|
-
|
-
|
2352
|
1
|
2352
|
-
|
-
|
-
|
-
|
-
|
-
|
2352
|
1
|
2352
|
|
Total
|
2352
|
1
|
2352
|
-
|
-
|
-
|
2352
|
1
|
2352
|
-
|
-
|
-
|
-
|
-
|
-
|
2352
|
1
|
2352
|
||
Trains
|
Collectable Wooden Train
|
2018.72
|
1
|
2018.72
|
-
|
-
|
-
|
2018.72
|
1
|
2018.72
|
-
|
-
|
-
|
-
|
-
|
-
|
2018.72
|
1
|
2018.72
|
|
Total
|
2018.72
|
1
|
2018.72
|
-
|
-
|
-
|
2018.72
|
1
|
2018.72
|
-
|
-
|
-
|
-
|
-
|
-
|
2018.72
|
1
|
2018.72
|
||
Total
|
82223.23
|
26
|
3162.4319230769
|
-
|
-
|
-
|
82223.23
|
26
|
3162.4319230769
|
-
|
-
|
-
|
-
|
-
|
-
|
82223.23
|
26
|
3162.4319230769
|
||
Anna's Decorations, Ltd
|
Trucks and Buses
|
1958 Setra Bus
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
10612.33
|
2
|
5306.165
|
10612.33
|
2
|
5306.165
|
10612.33
|
2
|
5306.165
|
1940 Ford Pickup Truck
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
6025.04
|
2
|
3012.52
|
6025.04
|
2
|
3012.52
|
6025.04
|
2
|
3012.52
|
||
1926 Ford Fire Engine
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
3863.64
|
2
|
1931.82
|
3863.64
|
2
|
1931.82
|
3863.64
|
2
|
1931.82
|
||
1940s Ford truck
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
3054.86
|
1
|
3054.86
|
3054.86
|
1
|
3054.86
|
3054.86
|
1
|
3054.86
|
||
1964 Mercedes Tour Bus
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
2241.14
|
1
|
2241.14
|
2241.14
|
1
|
2241.14
|
2241.14
|
1
|
2241.14
|
||
1996 Peterbilt 379 Stake Bed with Outrigger
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
1599.75
|
1
|
1599.75
|
1599.75
|
1
|
1599.75
|
1599.75
|
1
|
1599.75
|
||
Total
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
27396.76
|
9
|
3044.0844444444
|
27396.76
|
9
|
3044.0844444444
|
27396.76
|
9
|
3044.0844444444
|
||
Classic Cars
|
1962 LanciaA Delta 16V
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
8981.1
|
2
|
4490.55
|
8981.1
|
2
|
4490.55
|
8981.1
|
2
|
4490.55
|
|
1952 Alpine Renault 1300
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
4680.24
|
1
|
4680.24
|
4680.24
|
1
|
4680.24
|
4680.24
|
1
|
4680.24
|
||
1992 Ferrari 360 Spider red
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
4526.55
|
1
|
4526.55
|
4526.55
|
1
|
4526.55
|
4526.55
|
1
|
4526.55
|
||
Total
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
18187.89
|
4
|
4546.9725
|
18187.89
|
4
|
4546.9725
|
18187.89
|
4
|
4546.9725
|
||
Vintage Cars
|
1937 Lincoln Berline
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
3595.9
|
1
|
3595.9
|
3595.9
|
1
|
3595.9
|
3595.9
|
1
|
3595.9
|
|
1913 Ford Model T Speedster
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
3176.96
|
1
|
3176.96
|
3176.96
|
1
|
3176.96
|
3176.96
|
1
|
3176.96
|
||
1936 Mercedes-Benz 500K Special Roadster
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
1992.48
|
1
|
1992.48
|
1992.48
|
1
|
1992.48
|
1992.48
|
1
|
1992.48
|
||
1939 Chevrolet Deluxe Coupe
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
876.15
|
1
|
876.15
|
876.15
|
1
|
876.15
|
876.15
|
1
|
876.15
|
||
1938 Cadillac V-16 Presidential Limousine
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
870.96
|
1
|
870.96
|
870.96
|
1
|
870.96
|
870.96
|
1
|
870.96
|
||
1939 Cadillac Limousine
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
835.2
|
1
|
835.2
|
835.2
|
1
|
835.2
|
835.2
|
1
|
835.2
|
||
Total
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
11347.65
|
6
|
1891.275
|
11347.65
|
6
|
1891.275
|
11347.65
|
6
|
1891.275
|
||
Total
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
56932.3
|
19
|
2996.4368421053
|
56932.3
|
19
|
2996.4368421053
|
56932.3
|
19
|
2996.4368421053
|
||
Alpha Cognac
|
Ships
|
The Titanic
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
4135.2
|
1
|
4135.2
|
4135.2
|
1
|
4135.2
|
4135.2
|
1
|
4135.2
|
The Queen Mary
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
2895.84
|
1
|
2895.84
|
2895.84
|
1
|
2895.84
|
2895.84
|
1
|
2895.84
|
||
The Mayflower
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
2217.28
|
1
|
2217.28
|
2217.28
|
1
|
2217.28
|
2217.28
|
1
|
2217.28
|
||
Pont Yacht
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
1800.64
|
1
|
1800.64
|
1800.64
|
1
|
1800.64
|
1800.64
|
1
|
1800.64
|
||
The USS Constitution Ship
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
1383.36
|
1
|
1383.36
|
1383.36
|
1
|
1383.36
|
1383.36
|
1
|
1383.36
|
||
Total
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
12432.32
|
5
|
2486.464
|
12432.32
|
5
|
2486.464
|
12432.32
|
5
|
2486.464
|
||
Total
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
12432.32
|
5
|
2486.464
|
12432.32
|
5
|
2486.464
|
12432.32
|
5
|
2486.464
|
||
Atelier graphique
|
Motorcycles
|
1996 Moto Guzzi 1100i
|
4128.54
|
1
|
4128.54
|
-
|
-
|
-
|
4128.54
|
1
|
4128.54
|
-
|
-
|
-
|
-
|
-
|
-
|
4128.54
|
1
|
4128.54
|
1936 Harley Davidson El Knucklehead
|
1938.24
|
1
|
1938.24
|
-
|
-
|
-
|
1938.24
|
1
|
1938.24
|
-
|
-
|
-
|
-
|
-
|
-
|
1938.24
|
1
|
1938.24
|
||
Total
|
6066.78
|
2
|
3033.39
|
-
|
-
|
-
|
6066.78
|
2
|
3033.39
|
-
|
-
|
-
|
-
|
-
|
-
|
6066.78
|
2
|
3033.39
|
||
Vintage Cars
|
1938 Cadillac V-16 Presidential Limousine
|
-
|
-
|
-
|
1676.14
|
1
|
1676.14
|
1676.14
|
1
|
1676.14
|
-
|
-
|
-
|
-
|
-
|
-
|
1676.14
|
1
|
1676.14
|
|
Total
|
-
|
-
|
-
|
1676.14
|
1
|
1676.14
|
1676.14
|
1
|
1676.14
|
-
|
-
|
-
|
-
|
-
|
-
|
1676.14
|
1
|
1676.14
|
||
Total
|
6066.78
|
2
|
3033.39
|
1676.14
|
1
|
1676.14
|
7742.92
|
3
|
2580.9733333333
|
-
|
-
|
-
|
-
|
-
|
-
|
7742.92
|
3
|
2580.9733333333
|
||
Total
|
88290.01
|
28
|
3153.2146428571
|
101660.54
|
36
|
2823.9038888889
|
189950.55
|
64
|
2967.97734375
|
69364.62
|
24
|
2890.1925
|
69364.62
|
24
|
2890.1925
|
259315.17
|
88
|
2946.7632954545
|
||
PivotMatrix::create(array(
...
'map' => array(
'rowField' => function($rowField, $fieldInfo) {
$v = $dataField;
if ($v === 'customerName')
$v = 'Customer';
else if ($v === 'productLine')
$v = 'Category';
else if ($v === 'productName')
$v = 'Product';
return $v;
},
'columnField' => function($colField, $fieldInfo) {
$v = $dataField;
if ($v === 'orderYear')
$v = 'Year';
else if ($v === 'orderMonth')
$v = 'Month';
return $v;
},
'rowHeader' => function($rowHeader, $headerInfo) {
return $rowHeader;
},
'columnHeader' => function($colHeader, $headerInfo) {
return $colHeader;
},
'dataCell' => function($value, $cellInfo) {
return $value;
},
),
...
));
|
|||||||||||||||||||||||||||||||||||||
dollar_sales - sum
|
Year
orderQuarter
|
||||||||||||||||||||||||||||||||||||
Customer
Category
Product
|
|
||||||||||||||||||||||||||||||||||||
|
|
||||||||||||||||||||||||||||||||||||
Page size: |