Hello,
I tried to download the Pivot table using the below code from VIEW.
$IndividualPerformance->run()->exportToExcel(array(
"dataStores"=>array(
'performance'=>array(
"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),
'columnCollapseLevels' => array(1),
'width' => '100%',
'headerMap' => array(
'prod_tot - sum' => 'Team',
'prod_tot - count' => 'Salesperson | Rookie Join Date',
'1' => 'January',
'2' => 'February',
'3' => 'March',
'4' => 'April',
'5' => 'May',
'6' => 'June',
'7' => 'July',
'8' => 'August',
'9' => 'September',
'10' => 'October',
'11' => 'November',
'12' => 'December',
),
)
)
))->toBrowser('sample.xls');
After download the report has {{all}} instead of total.
Thanks for help.