KoolReport's Forum

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

'hideTotalRow' => true, 'hideTotalColumn' => true, 'hideSubtotalRow' => true, 'hideSubtotalColumn' => true, NOt run #835

Open victor opened this topic on on Apr 26, 2019 - 1 comments

victor commented on Apr 26, 2019

HI ,

 'hideTotalRow' => true,
'hideTotalColumn' => true,
'hideSubtotalRow' => true,
'hideSubtotalColumn' => true,

Not run in a pivot table. I have the last version.

Example PivotTable::create(array(

  "dataStore"=>$dataStore,
  "rowDimension"=>"row",
  "columnDimension"=>"column",
  "measures"=>array(
    $this->columna_get." - sum",
	$this->columna_get2." - sum"
  ),
  'headerMap' => array(
        $this->columna_get.' - sum' => $this->columna_texto,
        $this->columna_get2.' - sum' => $this->columna_texto2,
		1=>'Enero',2=>'Febrero',3=>'Marzo',4=>'Abril',5=>'Mayo',6=>'Junio',7=>'Julio',8=>'Agosto',9=>'Septiembre',10=>'Octubre',11=>'Noviembre',12=>'Diciembre',
		'Margen'=>'Total'
        
    ),
	'rowSort' => array( 'tipo_comision' => 'desc'),
	'columnSort' => array( 'anyo' => 'desc'),
	'totalName' => 'Margen',
	'rowCollapseLevels' => array(1),
    'columnCollapseLevels' => array(0),
	'width' => '100%',
     'hideTotalRow' => true,
	'hideTotalColumn' => true,
	'hideSubtotalRow' => true,
	'hideSubtotalColumn' => true,
     'showDataHeaders' => true,
		
	
));
David Winterburn commented on Apr 27, 2019

Hi Victor,

To hide the grand total row and column of PivotTable, please add the following CSS rule to your page:

.pivot-column-header-grand-total,
    .pivot-row-header-grand-total,
    .pivot-data-cell-row-grand-total,
    .pivot-data-cell-column-grand-total,
    .pivot-data-header-grand-total  {
        display: none !important;
    }

We will add the hideGrandTotalRow and hideGrandTotalColumn to later version of PivotTable. Thanks!

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
None yet

Pivot