Dear Team,

we have create a pivotTable report generate report view in column fields can,t be show

attached my code kindly need your help...

 public function setup()
    {
        $node = $this->src('Report')->query("SELECT  IssueID, YEAR(Issue_Date) as orderYear, MONTH(Issue_Date) as orderMonth, deptID, DepName, ProdID, Product_Name, Request_Number, Product_Qty, UOM, Product_Cost, Total_Cost, L1, L1_NAME, L2, L2_NAME, L3, L3_NAME, L4, L4_NAME, L5, L5_NAME FROM Stores_Expenses_table");

        $node->pipe(new Filter(array(
            array('DepName', 'startwith', 'a'),
            array('orderYear', '>', 2015),
        )))
        ->pipe(new ColumnMeta(array(
            "dollar_sales" => array(
                'type' => 'number',
                "prefix" => "$",
            ),
        )))
        ->saveTo($node2);

        $node2->pipe(new Pivot(array(
            "dimensions" => array(
                // "column" => "orderYear, orderQuarter, orderMonth, orderDay",
                 "column" => "orderYear, orderMonth",
                "row" => "L1, L2, L3, L4, L5",
                // "row" => "customerName, productLine",
            ),
            "aggregates" => array(
                "sum" => "Total_Cost",
                "count" => "Total_Cost",
                "avg" => "Total_Cost",
                'sum percent' => 'Total_Cost',
                'count percent' => 'Total_Cost',
            ),
        )))->pipe($this->dataStore('Qreport1'));

        $node2->pipe(new Pivot(array(
            "dimensions" => array(
                // "column" => "orderYear, orderQuarter, orderMonth, orderDay",
                "column" => "orderYear, orderMonth",
                "row" => "L1, L2, L3, L4, L5",
                // "row" => "customerName, productLine",
            ),
            "aggregates" => array(
                "sum" => "Total_Cost",
                "count" => "Total_Cost",
                "avg" => "Total_Cost",
                'sum percent' => 'Total_Cost',
                'count percent' => 'Total_Cost',
            ),
            'partialProcessing' => true,
        )))->pipe($this->dataStore('Qreport'));
    }

Attached screen shoot for your references (MY OUTPUT SCREEN )