# KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.

# PİVOT TABLE TOTAL CALCULATION #1710

Oya Kaynar opened this topic on on Nov 13 - 8 comments

Oya Kaynar commented on Nov 13

how to total calculation total = total - 'evsel atık'

salih hanifeoglu commented on Nov 13

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"
)
``````
Oya Kaynar commented on Nov 13

I don't want to add a new label. I just want to extract 'Evsel Atık' from the total.

Oya Kaynar commented on Nov 16

how can i make total account?

Sebastian Morales commented on Nov 16

Oya, pls explain your idea clearer, with screenshots and description if possible. Cheers,

Oya Kaynar commented on Nov 16

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));
``````
Sebastian Morales commented on Nov 17

Are you saying that your total column for evsel atık has no values? If you are, please check your source data to see if there's any row with value "evsel atık" that has WEIGHT value.

Oya Kaynar commented on Nov 17

"domestic waste" data is coming. Not adding "domestic waste" data to the total we want

Sebastian Morales commented on Nov 17

Show me your "domestic waste" data row.