PivotShowValuesAsType
Inheritance: java.lang.Object
public final class PivotShowValuesAsType
Represents the calculation type for the “Show Values As” feature of pivot field values.
Fields
| Field | Description |
|---|---|
| DIFFERENCE_FROM | Shows the value as the difference from a specified base item. |
| INDEX | Index calculation: (Cell Value \u8133 Grand Total of Grand Totals) / (Row Grand Total \u8133 Column Grand Total). |
| NORMAL | Represents raw value, no custom calculation. |
| PERCENTAGE_DIFFERENCE_FROM | Shows the value as percentage difference from a specified base item. |
| PERCENTAGE_OF | Shows the value as a percentage of a specified base item. |
| PERCENTAGE_OF_COLUMN | Shows the value as percentage of the column total. |
| PERCENTAGE_OF_PARENT_COLUMN_TOTAL | Shows the value as percentage of its parent column item total. |
| PERCENTAGE_OF_PARENT_ROW_TOTAL | Shows the value as percentage of its parent row item total. |
| PERCENTAGE_OF_PARENT_TOTAL | Shows the value as percentage of its parent item total in the specified base field. |
| PERCENTAGE_OF_ROW | Shows the value as percentage of the row total. |
| PERCENTAGE_OF_RUNNING_TOTAL_IN | Shows the value as percentage running total along the specified base field. |
| PERCENTAGE_OF_TOTAL | Shows the value as percentage of the grand total. |
| RANK_LARGEST_TO_SMALLEST | Ranks values from largest to smallest within the specified base field. |
| RANK_SMALLEST_TO_LARGEST | Ranks values from smallest to largest within the specified base field. |
| RUNNING_TOTAL_IN | Shows the value as a running total along the specified base field. |
Methods
| Method | Description |
|---|---|
| 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:
| Parameter | Type | Description |
|---|---|---|
| arg0 | java.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:
| Parameter | Type | Description |
|---|---|---|
| arg0 | long |
wait(long arg0, int arg1)
public final void wait(long arg0, int arg1)
Parameters:
| Parameter | Type | Description |
|---|---|---|
| arg0 | long | |
| arg1 | int |