Assume that I have a database table like below :

With above given data, I need to create a Pivot Table structured like below :

As my first attempt, I tried with :

Report Class

        $this->src('konst_pro')
            ->query($query)
            ->pipe(new Pivot(array(
                'dimensions' => array(
                    //  'column' => 'site_name',
                    'row' => 'site_name, item_name, suborder_code, suborder_qty'
                ))))
            ->pipe($this->dataStore('sw_item_order_report'));

Report View

 $dataStore = $this->dataStore('sw_item_order_report');
        PivotTable::create(array(
            'dataStore'=>$dataStore
        ));

So it gives me below output :

Which is not what I expected.. So any help would be appreciable.

Thanks in advanced !

FYI , I don't need the red colored text inside the table. Just included them for better understanding. :)

@David, Your solution worked for me. I removed total_req column from the aggregates because it looks much cleaner now. Now my pivot table shown as following :

As you can observe from the picture, the underlined total columns are not useful to my report because the blue colored represent the total of all the items of given stage and red colored represent the total of all the items of all the stages. So any suggestion to get rid of those columns ??

My updated code so far :

$this->src('konst_pro')
            ->query($query)
            ->pipe(new Pivot(array(
                'dimensions' => array(
                    //  'column' => 'site_name',
                    'row' => 'site_name, stage_name, item_name, suborder_code, suborder_date'
                    // stage_name is another column of my table
                ),

                "aggregates" => array(
                   // "sum" => "suborder_qty, total_req", --> removed the total_req
                    "sum" => "suborder_qty",
                )

            )))
            ->pipe($this->dataStore('sw_item_order_report')); 

@David Yes, I saw that question and I don't think that hiding fornt-end html elements will effect on pdf generating report .. Isn't it ??