KoolPivotTable - Powerful PHP Pivot TableKoolPivotTable - Powerful PHP Pivot TableFullVersion 3.8.0.0 released on 25/11/2016

Advanced - KoolPivotTable Styles

Map customer's name to the first letter:
Drag the filter field here.
Dollar Sales
Product LineProduct
First letter
Classic CarsMotorcyclesPlanesShipsTrainsTrucks and BusesVintage CarsGrand Total
A
B
C
D
E
F
G
H
I
K
L
M
N
O
P
Q
R
S
T
U
Grand Total
$323,789$132,740$70,876$50,543$11,779$73,273$245,973$908,974
$89,709$19,368$19,601$6,644$9,207$34,432$40,431$219,391
$307,075$51,183$68,909$68,107$6,533$100,017$210,458$812,282
$301,182$107,438$24,644$50,602$22,107$114,715$80,539$701,227
$396,017$76,853$98,601$94,884$28,045$99,157$185,985$979,542
$53,538$20,971$22,336$2,210$0$2,430$12,501$113,986
$107,160$63,227$64,293$58,967$18,249$0$84,052$395,948
$173,221$27,168$2,787$1,912$5,907$51,443$32,780$295,219
$20,008$0$0$0$2,833$24,672$3,475$50,988
$14,987$36,996$67,575$20,281$2,749$0$40,353$182,942
$224,390$122,280$67,388$37,236$17,521$68,528$50,033$587,377
$701,559$137,855$50,950$58,198$29,821$210,232$265,617$1,454,232
$36,799$0$25,719$0$0$0$6,541$69,059
$150,165$34,011$39,029$21,630$0$29,697$55,562$330,094
$4,080$0$0$25,591$6,188$0$34,993$70,852
$31,735$0$0$16,472$0$15,959$4,811$68,978
$75,964$21,512$125,889$36,025$4,181$6,216$80,755$350,542
$389,109$43,191$53,430$74,359$16,721$122,928$200,480$900,220
$224,392$166,772$146,034$33,031$3,658$34,935$105,188$714,010
$59,040$37,259$0$0$0$0$10,311$106,611
$3,853,922$1,121,426$954,638$663,998$188,533$1,024,114$1,797,560$9,604,191
Page 1 in 2, items 1 to 20 of 22.
DoneLoading..


Map customer's name to the first letter and then the name:
Drag the filter field here.
Dollar Sales
Product LineProduct
First letterCustomer
Classic CarsMotorcyclesPlanesShipsTrainsTrucks and BusesVintage CarsGrand Total
AAV Stores, Co.
Alpha Cognac
Amica Models & Co.
Anna's Decorations, Ltd
Atelier graphique
Australian Collectables, Ltd
Australian Collectors, Co.
Australian Gift Network, Co
Auto Associés & Cie.
Auto Canal+ Petit
Auto-Moto Classics Inc.
Sum of A
BBaane Mini Imports
Bavarian Collectables Imports, Co.
Blauer See Auto, Co.
Boards & Toys Co.
Sum of B
CCAF Imports
Cambridge Collectables Co.
Canadian Gift Exchange Network
Grand Total
$60,044$0$0$19,186$7,874$0$61,307$148,410
$17,399$0$16,555$18,279$0$0$8,250$60,483
$26,424$0$0$6,251$2,019$2,352$45,177$82,223
$79,041$16,402$0$0$0$27,397$14,195$137,034
$14,571$6,067$0$0$0$0$1,676$22,314
$11,072$0$3,095$2,346$0$0$39,353$55,866
$48,010$50,014$35,205$0$0$16,327$31,029$180,585
$15,002$13,342$8,091$0$1,887$10,086$6,783$55,190
$12,704$0$0$0$0$17,112$29,060$58,876
$39,522$46,915$0$0$0$0$0$86,437
$0$0$7,931$4,481$0$0$9,143$21,554
$323,789$132,740$70,876$50,543$11,779$73,273$245,973$908,974
$36,941$19,368$0$0$4,023$26,456$17,437$104,225
$0$0$19,601$4,510$0$0$7,199$31,310
$49,315$0$0$0$5,184$7,976$13,463$75,938
$3,453$0$0$2,134$0$0$2,332$7,919
$89,709$19,368$19,601$6,644$9,207$34,432$40,431$219,391
$15,323$0$0$19,658$2,690$0$9,080$46,751
$6,215$0$2,669$3,440$0$3,211$16,664$32,199
$24,660$0$0$0$0$30,407$15,055$70,122
$3,853,922$1,121,426$954,638$663,998$188,533$1,024,114$1,797,560$9,604,191
Page 1 in 6, items 1 to 20 of 120.
DoneLoading..

Description & Sample code

Value mapping allows one to change data of KoolPivotTable by their own-defined mapping functions with the following command:

$field->setValueMap(new simpleFirstLetterMap());

Those maps need to implement the PivotIValueMap interface which is placed in the same folder with KoolPivotTable php file.