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
|
$0
|
0
|
$3,296
|
1
|
$3,296
|
1
|
$0
|
0
|
$0
|
0
|
$3,296
|
1
|
|
1952 Citroen-15CV
|
$0
|
0
|
$4,754
|
1
|
$4,754
|
1
|
$0
|
0
|
$0
|
0
|
$4,754
|
1
|
||
|
1957 Ford Thunderbird
|
$0
|
0
|
$1,482
|
1
|
$1,482
|
1
|
$0
|
0
|
$0
|
0
|
$1,482
|
1
|
||
|
1966 Shelby Cobra 427 S/C
|
$0
|
0
|
$946
|
1
|
$946
|
1
|
$0
|
0
|
$0
|
0
|
$946
|
1
|
||
|
1969 Chevrolet Camaro Z28
|
$0
|
0
|
$3,506
|
1
|
$3,506
|
1
|
$0
|
0
|
$0
|
0
|
$3,506
|
1
|
||
|
1969 Corvair Monza
|
$4,931
|
1
|
$0
|
0
|
$4,931
|
1
|
$0
|
0
|
$0
|
0
|
$4,931
|
1
|
||
|
1969 Ford Falcon
|
$2,907
|
1
|
$0
|
0
|
$2,907
|
1
|
$0
|
0
|
$0
|
0
|
$2,907
|
1
|
||
|
1970 Chevy Chevelle SS 454
|
$0
|
0
|
$1,420
|
1
|
$1,420
|
1
|
$0
|
0
|
$0
|
0
|
$1,420
|
1
|
||
|
1970 Triumph Spitfire
|
$2,907
|
1
|
$0
|
0
|
$2,907
|
1
|
$0
|
0
|
$0
|
0
|
$2,907
|
1
|
||
|
2001 Ferrari Enzo
|
$5,669
|
1
|
$0
|
0
|
$5,669
|
1
|
$0
|
0
|
$0
|
0
|
$5,669
|
1
|
||
|
2002 Chevy Corvette
|
$0
|
0
|
$2,921
|
1
|
$2,921
|
1
|
$0
|
0
|
$0
|
0
|
$2,921
|
1
|
||
|
Total
|
$16,414
|
4
|
$18,324
|
7
|
$34,738
|
11
|
$0
|
0
|
$0
|
0
|
$34,738
|
11
|
||
|
Ships
|
18th century schooner
|
$3,172
|
1
|
$0
|
0
|
$3,172
|
1
|
$0
|
0
|
$0
|
0
|
$3,172
|
1
|
|
|
Pont Yacht
|
$1,682
|
1
|
$0
|
0
|
$1,682
|
1
|
$0
|
0
|
$0
|
0
|
$1,682
|
1
|
||
|
The Mayflower
|
$2,798
|
1
|
$0
|
0
|
$2,798
|
1
|
$0
|
0
|
$0
|
0
|
$2,798
|
1
|
||
|
The Queen Mary
|
$2,622
|
1
|
$0
|
0
|
$2,622
|
1
|
$0
|
0
|
$0
|
0
|
$2,622
|
1
|
||
|
The Schooner Bluenose
|
$3,067
|
1
|
$0
|
0
|
$3,067
|
1
|
$0
|
0
|
$0
|
0
|
$3,067
|
1
|
||
|
The Titanic
|
$3,173
|
1
|
$0
|
0
|
$3,173
|
1
|
$0
|
0
|
$0
|
0
|
$3,173
|
1
|
||
|
The USS Constitution Ship
|
$2,673
|
1
|
$0
|
0
|
$2,673
|
1
|
$0
|
0
|
$0
|
0
|
$2,673
|
1
|
||
|
Total
|
$19,186
|
7
|
$0
|
0
|
$19,186
|
7
|
$0
|
0
|
$0
|
0
|
$19,186
|
7
|
||
|
Trains
|
1950's Chicago Surface Lines Streetcar
|
$2,773
|
1
|
$0
|
0
|
$2,773
|
1
|
$0
|
0
|
$0
|
0
|
$2,773
|
1
|
|
|
1962 City of Detroit Streetcar
|
$1,753
|
1
|
$0
|
0
|
$1,753
|
1
|
$0
|
0
|
$0
|
0
|
$1,753
|
1
|
||
|
Collectable Wooden Train
|
$3,348
|
1
|
$0
|
0
|
$3,348
|
1
|
$0
|
0
|
$0
|
0
|
$3,348
|
1
|
||
|
Total
|
$7,874
|
3
|
$0
|
0
|
$7,874
|
3
|
$0
|
0
|
$0
|
0
|
$7,874
|
3
|
||
|
Vintage Cars
|
18th Century Vintage Horse Carriage
|
$0
|
0
|
$4,021
|
1
|
$4,021
|
1
|
$0
|
0
|
$0
|
0
|
$4,021
|
1
|
|
|
1903 Ford Model A
|
$3,672
|
1
|
$0
|
0
|
$3,672
|
1
|
$0
|
0
|
$0
|
0
|
$3,672
|
1
|
||
|
1904 Buick Runabout
|
$3,320
|
1
|
$0
|
0
|
$3,320
|
1
|
$0
|
0
|
$0
|
0
|
$3,320
|
1
|
||
|
1911 Ford Town Car
|
$0
|
0
|
$2,047
|
1
|
$2,047
|
1
|
$0
|
0
|
$0
|
0
|
$2,047
|
1
|
||
|
1912 Ford Model T Delivery Wagon
|
$2,360
|
1
|
$0
|
0
|
$2,360
|
1
|
$0
|
0
|
$0
|
0
|
$2,360
|
1
|
||
|
1928 Mercedes-Benz SSK
|
$0
|
0
|
$3,321
|
1
|
$3,321
|
1
|
$0
|
0
|
$0
|
0
|
$3,321
|
1
|
||
|
1932 Alfa Romeo 8C2300 Spider Sport
|
$0
|
0
|
$4,602
|
1
|
$4,602
|
1
|
$0
|
0
|
$0
|
0
|
$4,602
|
1
|
||
|
1932 Model A Ford J-Coupe
|
$0
|
0
|
$4,094
|
1
|
$4,094
|
1
|
$0
|
0
|
$0
|
0
|
$4,094
|
1
|
||
|
1934 Ford V8 Coupe
|
$0
|
0
|
$1,380
|
1
|
$1,380
|
1
|
$0
|
0
|
$0
|
0
|
$1,380
|
1
|
||
|
1936 Mercedes Benz 500k Roadster
|
$0
|
0
|
$1,413
|
1
|
$1,413
|
1
|
$0
|
0
|
$0
|
0
|
$1,413
|
1
|
||
|
1936 Mercedes-Benz 500K Special Roadster
|
$0
|
0
|
$1,383
|
1
|
$1,383
|
1
|
$0
|
0
|
$0
|
0
|
$1,383
|
1
|
||
|
1937 Lincoln Berline
|
$0
|
0
|
$4,111
|
1
|
$4,111
|
1
|
$0
|
0
|
$0
|
0
|
$4,111
|
1
|
||
|
1938 Cadillac V-16 Presidential Limousine
|
$0
|
0
|
$1,118
|
1
|
$1,118
|
1
|
$0
|
0
|
$0
|
0
|
$1,118
|
1
|
||
|
1939 Chevrolet Deluxe Coupe
|
$0
|
0
|
$1,344
|
1
|
$1,344
|
1
|
$0
|
0
|
$0
|
0
|
$1,344
|
1
|
||
|
Total
|
$9,352
|
3
|
$28,835
|
11
|
$38,187
|
14
|
$0
|
0
|
$0
|
0
|
$38,187
|
14
|
||
|
Total
|
$52,825
|
17
|
$47,159
|
18
|
$99,984
|
35
|
$0
|
0
|
$0
|
0
|
$99,984
|
35
|
||
|
Alpha Cognac
|
Ships
|
Pont Yacht
|
$0
|
0
|
$0
|
0
|
$0
|
0
|
$1,801
|
1
|
$1,801
|
1
|
$1,801
|
1
|
|
The Mayflower
|
$0
|
0
|
$0
|
0
|
$0
|
0
|
$2,217
|
1
|
$2,217
|
1
|
$2,217
|
1
|
||
|
The Queen Mary
|
$0
|
0
|
$0
|
0
|
$0
|
0
|
$2,896
|
1
|
$2,896
|
1
|
$2,896
|
1
|
||
|
The Titanic
|
$0
|
0
|
$0
|
0
|
$0
|
0
|
$4,135
|
1
|
$4,135
|
1
|
$4,135
|
1
|
||
|
The USS Constitution Ship
|
$0
|
0
|
$0
|
0
|
$0
|
0
|
$1,383
|
1
|
$1,383
|
1
|
$1,383
|
1
|
||
|
Total
|
$0
|
0
|
$0
|
0
|
$0
|
0
|
$12,432
|
5
|
$12,432
|
5
|
$12,432
|
5
|
||
|
Total
|
$0
|
0
|
$0
|
0
|
$0
|
0
|
$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. | 0 | 0 | 0 |
| Alpha Cognac | 0 | 0 | 0 |
| {{all}} | 0 | 0 | 0 |
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 | 0 | 0 | 0 | 0 | 0 | 0 |
| Classic Cars | 0 | 0 | 0 | 0 | 0 | 0 |
| Ships | 0 | 0 | 0 | 0 | 0 | 0 |
| Trains | 0 | 0 | 0 | 0 | 0 | 0 |
| {{all}} | 0 | 0 | 0 | 0 | 0 | 0 |