.
| Introducedin | ||||
|---|---|---|---|---|
|
| Description |
|---|
| Excerpt |
|---|
The ShowValueAsType class contains the Excel value field show value as types supported by ExcelWriter. |
...
| Signature | ||||
|---|---|---|---|---|
| ||||
Public NotInheritable Class ShowValueAsType |
| Remarks |
|---|
Values labels will return ShowValueAsType.Normal. You can check if a PivotField is values label with the IsValuesLabel Property |
| Values |
|---|
Name | Description | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Normal | Indicates that the field is shown as its normal data | |||||||
| DifferenceFrom | Indicates the field is shown as the "difference from" a | |||||||
| Indicates the field is show as the "percentage of" | ||||||||
| % Difference From | Indicates the field is shown as the "percentage | |||||||
| Running Total in | RunningTotal | Indicates the field is shown as running total in the | ||||||
| % Indicates the field is shown as the percentage of row | ||||||||
| % of column Indicates the field is shown as the percentage of | ||||||||
| % Indicates the field is shown as percentage of total. | ||||||||
| Indicates the field is shown as the index. |