PivotTable and PivotMatrix using Bun template
Bun template saves blank spaces when expanding rows in comparison to default template
PivotTable::create(array(
...
'template' => 'PivotTable-Bun',
...
));
dollar_sales - sum | dollar_sales - count | dollar_sales - avg
|
2004
|
2005
|
Total
|
|||||||||||||||
Total
|
$189,950
|
$64
|
$2,968
|
$69,365
|
$24
|
$2,890
|
$259,315
|
$88
|
$2,947
|
|||||||||
AV Stores, Co.
|
$99,984
|
$35
|
$2,857
|
-
|
-
|
-
|
$99,984
|
$35
|
$2,857
|
|||||||||
Vintage Cars
|
$38,187
|
$14
|
$2,728
|
-
|
-
|
-
|
$38,187
|
$14
|
$2,728
|
|||||||||
Classic Cars
|
$34,738
|
$11
|
$3,158
|
-
|
-
|
-
|
$34,738
|
$11
|
$3,158
|
|||||||||
Ships
|
$19,186
|
$7
|
$2,741
|
-
|
-
|
-
|
$19,186
|
$7
|
$2,741
|
|||||||||
Trains
|
$7,874
|
$3
|
$2,625
|
-
|
-
|
-
|
$7,874
|
$3
|
$2,625
|
|||||||||
Amica Models & Co.
|
$82,223
|
$26
|
$3,162
|
-
|
-
|
-
|
$82,223
|
$26
|
$3,162
|
|||||||||
Vintage Cars
|
$45,177
|
$17
|
$2,657
|
-
|
-
|
-
|
$45,177
|
$17
|
$2,657
|
|||||||||
Classic Cars
|
$26,424
|
$4
|
$6,606
|
-
|
-
|
-
|
$26,424
|
$4
|
$6,606
|
|||||||||
Ships
|
$6,251
|
$3
|
$2,084
|
-
|
-
|
-
|
$6,251
|
$3
|
$2,084
|
|||||||||
Trucks and Buses
|
$2,352
|
$1
|
$2,352
|
-
|
-
|
-
|
$2,352
|
$1
|
$2,352
|
|||||||||
Trains
|
$2,019
|
$1
|
$2,019
|
-
|
-
|
-
|
$2,019
|
$1
|
$2,019
|
|||||||||
Anna's Decorations, Ltd
|
-
|
-
|
-
|
$56,932
|
$19
|
$2,996
|
$56,932
|
$19
|
$2,996
|
|||||||||
Trucks and Buses
|
-
|
-
|
-
|
$27,397
|
$9
|
$3,044
|
$27,397
|
$9
|
$3,044
|
|||||||||
Classic Cars
|
-
|
-
|
-
|
$18,188
|
$4
|
$4,547
|
$18,188
|
$4
|
$4,547
|
|||||||||
Vintage Cars
|
-
|
-
|
-
|
$11,348
|
$6
|
$1,891
|
$11,348
|
$6
|
$1,891
|
|||||||||
Alpha Cognac
|
-
|
-
|
-
|
$12,432
|
$5
|
$2,486
|
$12,432
|
$5
|
$2,486
|
|||||||||
Ships
|
-
|
-
|
-
|
$12,432
|
$5
|
$2,486
|
$12,432
|
$5
|
$2,486
|
|||||||||
Atelier graphique
|
$7,743
|
$3
|
$2,581
|
-
|
-
|
-
|
$7,743
|
$3
|
$2,581
|
|||||||||
Motorcycles
|
$6,067
|
$2
|
$3,033
|
-
|
-
|
-
|
$6,067
|
$2
|
$3,033
|
|||||||||
Vintage Cars
|
$1,676
|
$1
|
$1,676
|
-
|
-
|
-
|
$1,676
|
$1
|
$1,676
|
|||||||||
PivotMatrix::create(array(
...
'template' => 'PivotMatrix-Bun',
...
));
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
dollar_sales - sum
dollar_sales - count
dollar_sales - avg
|
orderYear
orderQuarter
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
customerName
productLine
productName
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Page size: |
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