Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines
Hi Oya , maybe help you this url https://www.koolreport.com/docs/pivot/overview/ look at here array in sum like this
"aggregates"=>array(
"sum" => "dollar_sales",
"count" => "dollar_sales"
)
I NEED TOTAL CALCULATION : total = total - 'evsel atık'
I NEED TABLE
$dataStore = $this->getDataSource()->query($this->query)->pipe(new ColumnMeta(array(
"WEIGHT"=>array(
'type' => 'float',
))));
$dataStore->pipe(new Pivot(array(
"dimensions" => array(
"column" => "TURNAME",
"row" => "WDATE"
),
"aggregates"=>array(
"sum" => "WEIGHT"
),
)
))->pipe($this->dataStore($this->reportName));
Let KoolReport help you to make great reports. It's free & open-source released under MIT license.
Download KoolReport View demo