Hello,

I want to rename the Total to Grand Total in Pivot table.

I tried the headerMap, but it didnt work.

'headerMap' => array(
              'Total' => 'Grand Total <span class="grand_title">T.PROD | NO</span>',
)

Hello,

The above method didn't work, Can you please suggest another working way?

Thanks.

PivotTable::create(array(
            "dataStore"=>$dataStore,
            "rowDimension"=>"row",
            "columnDimension"=>"column",
            "measures"=>array(
              "prod_tot - sum",
              'prod_tot - count',
            ),
            'rowSort' => array(
              'prod_tot - count' => 'desc',
            ),
            'columnSort' => array(
              'created_month' => function($a, $b) {
                return (int)$a < (int)$b;
              },
            ),
            'rowCollapseLevels' => array(2), // 2
            'columnCollapseLevels' => array(0), // 1
            'width' => '100%',
            'headerMap' => array(
              'prod_tot - sum' => '<span id="header_name">Name<span>',
              'prod_tot - count' => '<span id="header_salesperson_name">Salesperson</span> | <span id="header_rookie_date">Rookie Join Date (<1 Year)<span>',
              '1' => 'January',
              '2' => 'February',
              '3' => 'March',
              '4' => 'April',
              '5' => 'May',
              '6' => 'June',
              '7' => 'July',
              '8' => 'August',
              '9' => 'September',
              '10' => 'October',
              '11' => 'November',
              '12' => 'December',
              'January' => 'January <span class="sub_title">T.PROD | NO</span>',
              'February' => 'February <span class="sub_title">T.PROD | NO</span>',
              'March' => 'March <span class="sub_title">T.PROD | NO</span>',
              'April' => 'April <span class="sub_title">T.PROD | NO</span>',
              'May' => 'May <span class="sub_title">T.PROD | NO</span>',
              'June' => 'June <span class="sub_title">T.PROD | NO</span>',
              'July' => 'July <span class="sub_title">T.PROD | NO</span>',
              'August' => 'August <span class="sub_title">T.PROD | NO</span>',
              'September' => 'September <span class="sub_title">T.PROD | NO</span>',
              'October' => 'October <span class="sub_title">T.PROD | NO</span>',
              'November' => 'November <span class="sub_title">T.PROD | NO</span>',
              'December' => 'December <span class="sub_title">T.PROD | NO</span>',
            ),
          ));