PDF Extract
The example shows how we can extract a table from multi-level tables of pivot.
The extracted table can be used to draw chart or any other purposes.
Original Pivot Table
|
dollar_sales - sum | dollar_sales - count
|
2004
|
2005
|
Total
|
|||||||||||
|
10
|
11
|
Total
|
3
|
Total
|
||||||||||
|
AV Stores, Co.
|
Classic Cars
|
1949 Jaguar XK 120
|
-
|
-
|
$3,296
|
$1
|
$3,296
|
$1
|
-
|
-
|
-
|
-
|
$3,296
|
$1
|
|
1952 Citroen-15CV
|
-
|
-
|
$4,754
|
$1
|
$4,754
|
$1
|
-
|
-
|
-
|
-
|
$4,754
|
$1
|
||
|
1957 Ford Thunderbird
|
-
|
-
|
$1,482
|
$1
|
$1,482
|
$1
|
-
|
-
|
-
|
-
|
$1,482
|
$1
|
||
|
1966 Shelby Cobra 427 S/C
|
-
|
-
|
$946
|
$1
|
$946
|
$1
|
-
|
-
|
-
|
-
|
$946
|
$1
|
||
|
1969 Chevrolet Camaro Z28
|
-
|
-
|
$3,506
|
$1
|
$3,506
|
$1
|
-
|
-
|
-
|
-
|
$3,506
|
$1
|
||
|
1969 Corvair Monza
|
$4,931
|
$1
|
-
|
-
|
$4,931
|
$1
|
-
|
-
|
-
|
-
|
$4,931
|
$1
|
||
|
1969 Ford Falcon
|
$2,907
|
$1
|
-
|
-
|
$2,907
|
$1
|
-
|
-
|
-
|
-
|
$2,907
|
$1
|
||
|
1970 Chevy Chevelle SS 454
|
-
|
-
|
$1,420
|
$1
|
$1,420
|
$1
|
-
|
-
|
-
|
-
|
$1,420
|
$1
|
||
|
1970 Triumph Spitfire
|
$2,907
|
$1
|
-
|
-
|
$2,907
|
$1
|
-
|
-
|
-
|
-
|
$2,907
|
$1
|
||
|
2001 Ferrari Enzo
|
$5,669
|
$1
|
-
|
-
|
$5,669
|
$1
|
-
|
-
|
-
|
-
|
$5,669
|
$1
|
||
|
2002 Chevy Corvette
|
-
|
-
|
$2,921
|
$1
|
$2,921
|
$1
|
-
|
-
|
-
|
-
|
$2,921
|
$1
|
||
|
Total
|
$16,414
|
$4
|
$18,324
|
$7
|
$34,738
|
$11
|
-
|
-
|
-
|
-
|
$34,738
|
$11
|
||
|
Ships
|
18th century schooner
|
$3,172
|
$1
|
-
|
-
|
$3,172
|
$1
|
-
|
-
|
-
|
-
|
$3,172
|
$1
|
|
|
Pont Yacht
|
$1,682
|
$1
|
-
|
-
|
$1,682
|
$1
|
-
|
-
|
-
|
-
|
$1,682
|
$1
|
||
|
The Mayflower
|
$2,798
|
$1
|
-
|
-
|
$2,798
|
$1
|
-
|
-
|
-
|
-
|
$2,798
|
$1
|
||
|
The Queen Mary
|
$2,622
|
$1
|
-
|
-
|
$2,622
|
$1
|
-
|
-
|
-
|
-
|
$2,622
|
$1
|
||
|
The Schooner Bluenose
|
$3,067
|
$1
|
-
|
-
|
$3,067
|
$1
|
-
|
-
|
-
|
-
|
$3,067
|
$1
|
||
|
The Titanic
|
$3,173
|
$1
|
-
|
-
|
$3,173
|
$1
|
-
|
-
|
-
|
-
|
$3,173
|
$1
|
||
|
The USS Constitution Ship
|
$2,673
|
$1
|
-
|
-
|
$2,673
|
$1
|
-
|
-
|
-
|
-
|
$2,673
|
$1
|
||
|
Total
|
$19,186
|
$7
|
-
|
-
|
$19,186
|
$7
|
-
|
-
|
-
|
-
|
$19,186
|
$7
|
||
|
Trains
|
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
|
||
|
Collectable Wooden Train
|
$3,348
|
$1
|
-
|
-
|
$3,348
|
$1
|
-
|
-
|
-
|
-
|
$3,348
|
$1
|
||
|
Total
|
$7,874
|
$3
|
-
|
-
|
$7,874
|
$3
|
-
|
-
|
-
|
-
|
$7,874
|
$3
|
||
|
Vintage Cars
|
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
|
||
|
1911 Ford Town Car
|
-
|
-
|
$2,047
|
$1
|
$2,047
|
$1
|
-
|
-
|
-
|
-
|
$2,047
|
$1
|
||
|
1912 Ford Model T Delivery Wagon
|
$2,360
|
$1
|
-
|
-
|
$2,360
|
$1
|
-
|
-
|
-
|
-
|
$2,360
|
$1
|
||
|
1928 Mercedes-Benz SSK
|
-
|
-
|
$3,321
|
$1
|
$3,321
|
$1
|
-
|
-
|
-
|
-
|
$3,321
|
$1
|
||
|
1932 Alfa Romeo 8C2300 Spider Sport
|
-
|
-
|
$4,602
|
$1
|
$4,602
|
$1
|
-
|
-
|
-
|
-
|
$4,602
|
$1
|
||
|
1932 Model A Ford J-Coupe
|
-
|
-
|
$4,094
|
$1
|
$4,094
|
$1
|
-
|
-
|
-
|
-
|
$4,094
|
$1
|
||
|
1934 Ford V8 Coupe
|
-
|
-
|
$1,380
|
$1
|
$1,380
|
$1
|
-
|
-
|
-
|
-
|
$1,380
|
$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
|
||
|
1937 Lincoln Berline
|
-
|
-
|
$4,111
|
$1
|
$4,111
|
$1
|
-
|
-
|
-
|
-
|
$4,111
|
$1
|
||
|
1938 Cadillac V-16 Presidential Limousine
|
-
|
-
|
$1,118
|
$1
|
$1,118
|
$1
|
-
|
-
|
-
|
-
|
$1,118
|
$1
|
||
|
1939 Chevrolet Deluxe Coupe
|
-
|
-
|
$1,344
|
$1
|
$1,344
|
$1
|
-
|
-
|
-
|
-
|
$1,344
|
$1
|
||
|
Total
|
$9,352
|
$3
|
$28,835
|
$11
|
$38,187
|
$14
|
-
|
-
|
-
|
-
|
$38,187
|
$14
|
||
|
Total
|
$52,825
|
$17
|
$47,159
|
$18
|
$99,984
|
$35
|
-
|
-
|
-
|
-
|
$99,984
|
$35
|
||
|
Alpha Cognac
|
Ships
|
Pont Yacht
|
-
|
-
|
-
|
-
|
-
|
-
|
$1,801
|
$1
|
$1,801
|
$1
|
$1,801
|
$1
|
|
The Mayflower
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,217
|
$1
|
$2,217
|
$1
|
$2,217
|
$1
|
||
|
The Queen Mary
|
-
|
-
|
-
|
-
|
-
|
-
|
$2,896
|
$1
|
$2,896
|
$1
|
$2,896
|
$1
|
||
|
The Titanic
|
-
|
-
|
-
|
-
|
-
|
-
|
$4,135
|
$1
|
$4,135
|
$1
|
$4,135
|
$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
|
||
|
Total
|
$52,825
|
$17
|
$47,159
|
$18
|
$99,984
|
$35
|
$12,432
|
$5
|
$12,432
|
$5
|
$112,417
|
$40
|
||
Extracted Table 1
| customerName | 2004 | 2005 | {{all}} |
|---|---|---|---|
| AV Stores, Co. | 99,984 | 0 | 99,984 |
| Alpha Cognac | 0 | 12,432 | 12,432 |
| {{all}} | 99,984 | 12,432 | 112,417 |
Extracted Table 2
| productLine | 10 | dollar_sales - sum | 10 | dollar_sales - count | 11 | dollar_sales - sum | 11 | dollar_sales - count | {{all}} | dollar_sales - sum | {{all}} | dollar_sales - count |
|---|---|---|---|---|---|---|
| Vintage Cars | 9,352 | 3 | 28,835 | 11 | 38,187 | 14 |
| Classic Cars | 16,414 | 4 | 18,324 | 7 | 34,738 | 11 |
| Ships | 19,186 | 7 | 0 | 0 | 19,186 | 7 |
| Trains | 7,874 | 3 | 0 | 0 | 7,874 | 3 |
| {{all}} | 52,825 | 17 | 47,159 | 18 | 99,984 | 35 |