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

 

Pivot

<< Click to Display Table of Contents >>

Navigation:  »No topics above this level«

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

 

Pivot

 

 

Change pivot row or pivot column.

 

 

 

Prototype :

 

void Pivot

(

        integer FromAxis,

        integer FromLevel,

        integer ToAxis,

        integer ToLevel

)

 

void Pivot

(

        string FromAxis,

        integer FromLevel,

        string ToAxis,

        integer ToLevel

)

 

 

 

Arguments :

 

FromAxis

source pivot move from

0 or "y" for pivot row

1 or "x" for column pivot

FromLevel

level of the source pivot

ToAxis

target pivot move to

0 or "y" for pivot row

1 or "x" for column pivot

ToLevel

level of the target pivot

 

 

 

Reference :

 

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

 

 

 

Example :

 

//exchange the 1st pivot row and 1st pivot column

//set pivot using number

 This.Pivot(0, 0, 1, 0);

 

//exchange the 2nd pivot row and 2nd pivot column

//set pivot using character

 This.Pivot("y", 1, "x", 1);

 

 

 

Available Events :

 

All Events