addColHeader

Add fields to the header of the pivot

Pivot1.binding.addColHeader(dimCol);

addMeasure

Add a summary field to the pivot

Pivot1.binding.addMeasure(meaCol);

addRowHeader

Add a row header field to the pivot

Pivot1.binding.addRowHeader(dimCol);

clearColHeaders

Clear the list header field of the pivot

Pivot1.binding.clearColHeaders();

clearMeasures

Clear the summary field of the pivot

Pivot1.binding.clearMeasures();

clearRowHeaders

Clear the pivot row header fields

Piovt1.binding.clearRowHeaders();

colGrps

Bind an array to the header of the pivot

Pivot1.binding.colGrps=arr;//var arr=[dimCol1,dimCol2];

colHeaderCount

Returns the number of column headers in the pivot

var c= pivot1.banding.colHeaderCount;

getColHeader

Get the list header field information of the pivot

var a =Pivot1.binding.getColHeader(0);

getMeasure

Get the summary table field information of the pivot

var a =Pivot1.binding.getMeasure(0);

getRowHeader

Get the pivot row header field information

var a =Pivot1.binding.getRowHeader(0);

measureCount

Get the number of summarized fields in the pivot

var a=Pivot1.binding.measureCount;

measures

Bind data to a pivot summary row

Pivot1.binding.setMeasures=arr;//var arr=[mCol1,mCol2];

removeColHeader

Remove pivot column fields

Pivot1.binding.removeColHeader(0);

removeMeasure

Remove summary data segment

Pivot1.binding.removeMeasure(0);

removeRowHeader

Remove pivot row fields

Pivot1.binding.removeRowHeader(0);

rowGrps

Bind an array to the row header of the pivot

Pivot1.binding.rowGrps=arr;//var arr=[dimCol1,dimCol2];

rowHeaderCount

Returns the number of fields in the row header

var c =Pivot1.binding.rowHeaderCount;

setColHeader

Bind fields to the header of the pivot

Pivot1.binding.setColHeader(0,dimcol);

setMeasure

Bind data to a crosstab summary row

Pivot1.binding.setMeasure(0，mcol);

setRowHeader

Row header binding field for pivot

Pivot1.binding.setRowHeader(0,dimcol);

setNegativeColor

Set the negative color in table rendering. 

var color = new Color(java.awt.Color.RED); 

var loc = new Locator(["Sum_Sales"], CELL, DETAIL);

Table1.setNegativeColor(loc, color);

setRenderColor

Set the color of bar or shape in table rendering. 

var color = new Color(java.awt.Color.RED); 

var loc = new Locator(["Sum_Sales"], CELL, DETAIL);

Table1.setRenderColor(loc, color);

showCTotal

Whether to display the subtotal of the number of columns in the pivot

Pivot1.binding.showCTotal = true;

showMeasureHeader

Display summary fields in a pivot

Pivot1.binding.showMeasureHeader=true;

showRTotal

Whether to display the cross-tab of the pivot row

Pivot1.binding.showRTotal = true;

vertical

pivot index names are arranged horizontally or vertically

Pivot1.binding.vertical=true;

spanTopLeft

Whether the intersection of the row header and the list header of the pivot is merged

Pivot1.binding.spanTopLeft = true;

nullAsCharacter

Whether the pivot area empty data is displayed as the specified character, for example, the null data is represented by the letter 'a'

Pivot1.nullAsCharacter =’a’;

maxRows

Set the maximum number of rows displayed in the pivot

Pivot1.maxRows=100;