Hello,

in the widget Table:: I have the possibility to format each column and field by using label, align, decimal, decimalPoint properties (see below).

I tried the same in PivotTable:: but without any success!

Table::create(array(

"dataStore"=>$this->dataStore('sales_by_customer'),
    "columns"=>array(
        "customerName"=f>array(
            "label"=>"Customer"
        ),
        "dollar_sales"=>array(
            "type"=>"number",
            "label"=>"Amount",
            "prefix"=>"$",
        )
    ),

Any idea how to format for example the "price" values in a PivotTable for each summary field?

Kind regards

I piped in my function setup() the corresponding CoulumnMeta before Pivot process as below, but unfortunately the result is still like 1,234 instead of 1.234,56 (see below the screenshot)

function setup()
{
	// MultiSelect-Optionswerte aus ETL.Werbegruppen holen
	$this->src('autorep')

... ...

    ->pipe($this->dataStore("Reporting.autorep_v_ProduktGruppen"));

... ...

	))
	->pipe(new ColumnMeta(array(
                "Umsatz"=>array(
	    "align"=>"right",
                "type"=>"number",
                "prefix"=>"",
	    "suffix"=>"",
	    "decimals"=>2,
	    "thousandSeparator"=>".",
	    "decimalPoint"=>",",
        )
	)))
	
	->pipe(new Pivot(array(
		"dimensions" => array(
		"column" => "Monat",
		"row" => "WerbegruppeVerbund, NikonKdName, NikonProdGruppe"
		),
		"aggregates" => array(
		"sum" => "Umsatz",
		//"sum" => "Umsatz, Verkaufsmenge",
	)
	)))
	->pipe($this->dataStore('Reporting.autorep_v_noNulls')); 
	//echo $this->params["Werbegruppe"];		
} 

Thx a lot! Just replaced it and it works fine!

Only the property "align"=>"right" (cell alignment right in the table) seems not working!

Is there may be an other property for that?

OK understood. Thx a lot again!

I would like to share my temporary solution for alignment:

I did it via CSS in the class:

.pivot-data-cell { text-align: right; }

hi bysystem

Can you let me know if/how you have removed the Total Column from a pivot, I can't figure that out.

Any help is appreciated.

Thank you

Hi Hallie,

in my screenshot above unfortunately you could not see the total row. So I did not removed it !

No idea how to remove it with the widget properties. But I assume you should be able to do it probably via CSSfor the dedicated row/column like style="display:none" ???

Hi, I can't figure out how to add the css to the table data-column-index, tries alot of different ways.

Here's what I need to HIDE <td class="pivot-data-cell" data-row-index="0" data-column-index="3" data-layer="1">

Here's an example of my last try.

pivot-data-cell:nth-child(1) {

  background: red;

}

Any suggestions?

Hi, may be you should upgrade to the new version 1.47 of koolreport (I did not test it yet). But in the chage log I saw one new feature:

1. Enhancment: Ability to set cssStyle for each columns. cssStyle can be string or array containing components td,th and tf.

May be this helps!?