TOC : Script API > JavaScript > JavaScript API > Component > Multiplex > Crosstab > Method >

 

RemovePivot

<< Click to Display Table of Contents >>

Navigation:  »No topics above this level«

TOC : Script API > JavaScript > JavaScript API > Component > Multiplex > Crosstab > Method >

 

RemovePivot

 

 

Remove pivot row or pivot column.

 

 

 

Prototype :

 

void RemovePivot

(

        integer Axis,

        integer Level

)

 

void RemovePivot

(

        string Axis,

        integer Level

)

 

 

 

Arguments :

 

Axis

0 or "y" for pivot row and 1 or "x" for column pivot

Level

pivot level to remove

 

 

 

Reference :

 

 The highest pivot level is 0 and the lower level is increased by 1.

 

 

 

Example :

 

//remove the 1st pivot row

//set pivot using number

 This.RemovePivot(0, 0);

 

//remove two pivot rows

//after removing the 1st pivot row, the 2nd pivot row become level 0.

 This.RemovePivot(0, 0);

 This.RemovePivot(0, 0);

//or

 This.RemovePivot(0, 1);

 This.RemovePivot(0, 0);

 

 

 

Available Events :

 

All Events