PivotShowValuesAsType

Inheritance: java.lang.Object

public final class PivotShowValuesAsType

Represents the calculation type for the “Show Values As” feature of pivot field values.

Fields

FieldDescription
DIFFERENCE_FROMShows the value as the difference from a specified base item.
INDEXIndex calculation: (Cell Value \u8133 Grand Total of Grand Totals) / (Row Grand Total \u8133 Column Grand Total).
NORMALRepresents raw value, no custom calculation.
PERCENTAGE_DIFFERENCE_FROMShows the value as percentage difference from a specified base item.
PERCENTAGE_OFShows the value as a percentage of a specified base item.
PERCENTAGE_OF_COLUMNShows the value as percentage of the column total.
PERCENTAGE_OF_PARENT_COLUMN_TOTALShows the value as percentage of its parent column item total.
PERCENTAGE_OF_PARENT_ROW_TOTALShows the value as percentage of its parent row item total.
PERCENTAGE_OF_PARENT_TOTALShows the value as percentage of its parent item total in the specified base field.
PERCENTAGE_OF_ROWShows the value as percentage of the row total.
PERCENTAGE_OF_RUNNING_TOTAL_INShows the value as percentage running total along the specified base field.
PERCENTAGE_OF_TOTALShows the value as percentage of the grand total.
RANK_LARGEST_TO_SMALLESTRanks values from largest to smallest within the specified base field.
RANK_SMALLEST_TO_LARGESTRanks values from smallest to largest within the specified base field.
RUNNING_TOTAL_INShows the value as a running total along the specified base field.

Methods

MethodDescription
equals(Object arg0)
getClass()
hashCode()
notify()
notifyAll()
toString()
wait()
wait(long arg0)
wait(long arg0, int arg1)

DIFFERENCE_FROM

public static final int DIFFERENCE_FROM

Shows the value as the difference from a specified base item.

Remarks

Base field and base item are required.

INDEX

public static final int INDEX

Index calculation: (Cell Value \u8133 Grand Total of Grand Totals) / (Row Grand Total \u8133 Column Grand Total).

NORMAL

public static final int NORMAL

Represents raw value, no custom calculation.

PERCENTAGE_DIFFERENCE_FROM

public static final int PERCENTAGE_DIFFERENCE_FROM

Shows the value as percentage difference from a specified base item.

Remarks

Base field and base item are required.

PERCENTAGE_OF

public static final int PERCENTAGE_OF

Shows the value as a percentage of a specified base item.

Remarks

Base field and base item are required.

PERCENTAGE_OF_COLUMN

public static final int PERCENTAGE_OF_COLUMN

Shows the value as percentage of the column total.

PERCENTAGE_OF_PARENT_COLUMN_TOTAL

public static final int PERCENTAGE_OF_PARENT_COLUMN_TOTAL

Shows the value as percentage of its parent column item total.

PERCENTAGE_OF_PARENT_ROW_TOTAL

public static final int PERCENTAGE_OF_PARENT_ROW_TOTAL

Shows the value as percentage of its parent row item total.

PERCENTAGE_OF_PARENT_TOTAL

public static final int PERCENTAGE_OF_PARENT_TOTAL

Shows the value as percentage of its parent item total in the specified base field.

Remarks

Base field is required.

PERCENTAGE_OF_ROW

public static final int PERCENTAGE_OF_ROW

Shows the value as percentage of the row total.

PERCENTAGE_OF_RUNNING_TOTAL_IN

public static final int PERCENTAGE_OF_RUNNING_TOTAL_IN

Shows the value as percentage running total along the specified base field.

Remarks

Base field is required.

PERCENTAGE_OF_TOTAL

public static final int PERCENTAGE_OF_TOTAL

Shows the value as percentage of the grand total.

RANK_LARGEST_TO_SMALLEST

public static final int RANK_LARGEST_TO_SMALLEST

Ranks values from largest to smallest within the specified base field.

Remarks

Base field is required.

RANK_SMALLEST_TO_LARGEST

public static final int RANK_SMALLEST_TO_LARGEST

Ranks values from smallest to largest within the specified base field.

Remarks

Base field is required.

RUNNING_TOTAL_IN

public static final int RUNNING_TOTAL_IN

Shows the value as a running total along the specified base field.

Remarks

Base field is required.

equals(Object arg0)

public boolean equals(Object arg0)

Parameters:

ParameterTypeDescription
arg0java.lang.Object

Returns: boolean

getClass()

public final native Class<?> getClass()

Returns: java.lang.Class

hashCode()

public native int hashCode()

Returns: int

notify()

public final native void notify()

notifyAll()

public final native void notifyAll()

toString()

public String toString()

Returns: java.lang.String

wait()

public final void wait()

wait(long arg0)

public final native void wait(long arg0)

Parameters:

ParameterTypeDescription
arg0long

wait(long arg0, int arg1)

public final void wait(long arg0, int arg1)

Parameters:

ParameterTypeDescription
arg0long
arg1int