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
$120,087$0$0$38,372$15,747$0$122,614$148,410
$34,798$0$33,110$36,558$0$0$16,501$60,483
$52,848$0$0$12,502$4,037$4,704$90,354$82,223
$158,081$32,804$0$0$0$54,794$28,390$137,034
$29,143$12,134$0$0$0$0$3,352$22,314
$22,144$0$6,190$4,692$0$0$78,706$55,866
$96,020$100,029$70,410$0$0$32,653$62,059$180,585
$30,005$26,684$16,181$0$3,773$20,172$13,566$55,190
$25,409$0$0$0$0$34,225$58,119$58,876
$79,044$93,830$0$0$0$0$0$86,437
$0$0$15,862$8,962$0$0$18,285$21,554
$323,789$132,740$70,876$50,543$11,779$73,273$245,973$908,974
$73,883$38,735$0$0$8,046$52,912$34,874$104,225
$0$0$39,202$9,020$0$0$14,399$31,310
$98,629$0$0$0$10,368$15,952$26,926$75,938
$6,906$0$0$4,267$0$0$4,664$7,919
$89,709$19,368$19,601$6,644$9,207$34,432$40,431$219,391
$30,646$0$0$39,316$5,381$0$18,159$46,751
$12,429$0$5,339$6,879$0$6,422$33,328$32,199
$49,321$0$0$0$0$60,813$30,110$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.