KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

PİVOT TABLE TOTAL CALCULATION #1710

Open Oya Kaynar opened this topic on on Nov 13, 2020 - 8 comments

Oya Kaynar commented on Nov 13, 2020

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

salih hanifeoglu commented on Nov 13, 2020

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, 2020

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, 2020

how can i make total account?

Sebastian Morales commented on Nov 16, 2020

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

Oya Kaynar commented on Nov 16, 2020

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, 2020

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, 2020

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

Sebastian Morales commented on Nov 17, 2020

Show me your "domestic waste" data row.

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
help needed

None