How to use Pivot with Mysql

Hi Entahsiapa,

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'));

thanks