Class PivotShowValuesSetting
Namespace: Aspose.Cells.Pivot
Assembly: Aspose.Cells.dll (25.2.0)
Represents the settings about showing values as when the ShowDataAs calculation is in use.
public class PivotShowValuesSettingInheritance
object ← PivotShowValuesSetting
Inherited Members
object.GetType(), object.MemberwiseClone(), object.ToString(), object.Equals(object?), object.Equals(object?, object?), object.ReferenceEquals(object?, object?), object.GetHashCode()
Properties
BaseFieldIndex
Represents the base field for a ShowDataAs calculation when the ShowDataAs calculation is in use.
public int BaseFieldIndex { get; set; }Property Value
BaseItemIndex
Represents the custom index of the pivot item in the base field when the ShowDataAs calculation is in use. Valid only for data fields.
public int BaseItemIndex { get; set; }Property Value
BaseItemPositionType
Represents type of the base pivot item in the base field when the ShowDataAs calculation is in use. Valid only for data fields. Because PivotItemPosition.Custom is only for read,if you need to set PivotItemPosition.Custom, please set PivotField.BaseItemIndex attribute.
public PivotItemPositionType BaseItemPositionType { get; set; }Property Value
CalculationType
Represents how to show values of a data field in the pivot report.
public PivotFieldDataDisplayFormat CalculationType { get; set; }