Page History

{introducedin: 8.4}

{description}


{excerpt}
The ShowValueAsType class contains the Excel value field show value as types supported by ExcelWriter.{excerpt}
{signature:C#} public sealed class ShowValueAsType{signature}{signature:vb.net}Public NotInheritable Class ShowValueAsType{signature}


{remarks}Values labels will return ShowValueAsType.Normal. You can check if a PivotField is values label with the [IsValuesLabel |EW8:PivotTableField.IsValuesLabel]Property
{remarks}

{values}

|| Name || Description ||
| {anchor:Normal}Normal | Indicates that the field is shown as its normal data \type. |
| {anchor:Difference}Difference | Indicates the field is shown as the "difference from" a \value. |
| {anchor:Percent}Percent | Indicates the field is show as the "percentage of" |
| {anchor:PercentDiff} PercentDiff | Indicates the field is shown as the "percentage \difference from" a value. |
| {anchor:RunningTotal}RunningTotal | Indicates the field is shown as running total in the \table. |
| {anchor:PercentRow}PercentRow | Indicates the field is shown as the percentage of row |
| {anchor:PercentColumn}PercentColumn | Indicates the field is shown as the percentage of \column. |
| {anchor:PercentTotal}PercentTotal | Indicates the field is shown as percentage of total. |
| {anchor:Index}Index | Indicates the field is shown as the index. |