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
|
|||||||||||
AV Stores, Co.
|
||||||||||||||
$99,984
|
$35
|
-
|
-
|
$99,984
|
$35
|
|||||||||
Alpha Cognac
|
||||||||||||||
-
|
-
|
$12,432
|
$5
|
$12,432
|
$5
|
|||||||||
Total
|
$99,984
|
$35
|
$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 |
What People Are Saying
"KoolReport helps me very much in creating data report for my corporate! Keep up your good work!"
--
Alain Melsens
"The first use of your product. I was impressed by its easiness and powerfulness. This product is a great and amazing."
--
Dr. Lew Choy Onn
"Fantastic framework for reporting!"
--
Greg Schneider