Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
the database is indifferent.
You can take an example like this and try with your mysql ddbb
$node = $this->src('dollarsales'); //here your data conection [......] ->pipe(new Pivot(array( //here define your pivot structure -> row/column 'dimensions'=>array( 'row'=>'customerName, productLine, productName' ), [......] ->pipe($this->dataStore('sales'));
KoolReport is a professionalwhich saves you to construct .