Dear support, I am trying to name the aggregate columns in pivot table, but can`t find solution, can you please help?

This is my setup: $this->src('deptdata')

        ->query($sql)
        ->params($params)
        ->pipe(new ColumnMeta(array(
            "init_balance" => array(
                'label' => 'Balance',
                'type'  => 'float',
            ),
            "income" => array(
                'label' => 'Income',
                'type'  => 'float',
            ),
        )))
        ->pipe(new Pivot(array(
            "dimensions" => array(
                "column" => "",
                "row" => "client, currency, agreement_type, agreement, date",
            ),
            "aggregates" => array(
                "sum" => "init_balance, income, outcome, final_balance",
            ),
        )))
        ->pipe($this->dataStore('deptreport'));

This is my view: PivotTable::create(array(

        "dataStore"=>$this->dataStore('deptreport'),
        'headerMap' => array(
            'init_balance - sum' => 'Initial Ballance',
            'income - sum' => 'Income',
            'outcome - sum' => 'Outcome',
            'final_balance - sum' => 'Final Ballance',
        ),
    ));

Where can I add names for aggregate columns ('Initial Balance', 'Income', 'Outcome', 'Final Balance'?

I think there is simple solution, but I can`t find in documentation.

Can you please help?

Hi David,

Sorry for confusing you I had to be more specific.

My boss want me to name "Total" columns like that:

I was trying to find some examples on your forum, but couldn't.

I am using "headerMap" but it is working only on the left top corner (as you can see).

Dear David,

That`s good news. Thanks, will wait for new release.

Dear Koolreport team. You did it, it really work in v.3

Thank you. You are the best! :)

The only thing I face is that I can`t give aliases to more then 4 columns. Can you pls take a look if I did some thing wrong.

    PivotTable::create(array(
        "dataStore"=>$this->dataStore('ofstoreport'),
        'headerMap' => array(
            'init_count_balance - sum' => 'Initial count balance',
            'count_income - sum' => 'Count Income',
            'count_outcome - sum' => 'Count Outcome',
            'final_count_balance - sum' => 'Final count balance',
            'init_summ_balance - sum' => 'Initial summ balance',
            'summ_income - sum' => 'Summ Income',
            'summ_outcome - sum' => 'Summ Outcome',
            'final_summ_balance - sum' => 'Final summ balance'
        ),
        'hideSubtotalRow' => true,
        'hideSubtotalColumn' => true,
        'showDataHeaders' => true,
    )); 

but as you can see only 4 of headerMap aliases is ok.

Dear support,

good day,

can you pls help with this issue?

Hi David, sure, this is my Pivot process code:

$this->src('ofstordata')

        ->query($sql)
        ->params($params)
        ->pipe(new ColumnMeta(array(
            "init_balance" => array(
                'label' => 'Balance',
                'type'  => 'float',
            ),
            "income" => array(
                'label' => 'Income',
                'type'  => 'float',
            ),
        )))
        ->pipe(new Pivot(array(
            "dimensions" => array(
                "column" => "",
                "row" => "storage, offer, name",
            ),
            "aggregates" => array(
                "sum" => "init_count_balance, count_income, count_outcome, final_count_balance",
                "init_summ_balance, summ_income, summ_outcome, final_summ_balance"
            ),
        )))
        ->pipe($this->dataStore('ofstoreport'));

Dear support. Good day. Is there any chance to get help from you?

Hi David,

Thank you for your reply. This was my mistake, I can see it now. Thanks again :)