PivotGridValueType Enum

Lists values that specify the types of column and row field values.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v17.2.Core.dll

Declaration

C#

public enum PivotGridValueType

VB.NET

Public Enum PivotGridValueType

Members

Name	Description
Value	Corresponds to a field value.
Total	Corresponds to an automatic total.
GrandTotal	Corresponds to a grand total.
CustomTotal	Corresponds to a custom total.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the PivotGridValueType enum.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

VB.NET

how-to-create-a-custom-chart-data-source-e2520/VB/CustomChartDataSourceWin/CustomChartDataSource.vb#L78

Select Case cell.ColumnValueType
    Case PivotGridValueType.CustomTotal
        Return result.AppendFormat(" Total ({0})", cell.ColumnCustomTotal.SummaryType).ToString()

how-to-display-custom-text-within-data-cells-e2232/VB/DXPivotGrid_FormattingViaEvents_VB/MainWindow.xaml.vb#L22

                                        ByVal e As PivotCellDisplayTextEventArgs)
If e.RowValueType <> PivotGridValueType.GrandTotal OrElse
    e.ColumnValueType = PivotGridValueType.GrandTotal OrElse

aspxpivotgrid-how-to-provide-custom-cell-appearance-t590081/VB/CellAppearanceCustomization/Default.aspx.vb#L19

End If
If e.ColumnValueType = PivotGridValueType.Value AndAlso e.RowValueType = PivotGridValueType.Value Then
    e.CellStyle.BackColor = Color.FromArgb(240, 240, 240)

how-to-customize-cell-appearance-via-templates-e1870/VB/ASPxPivotGrid_CellTemplates/Default.aspx.vb#L35

cell.Height = Unit.Pixel(20)
If templateContainer.Item.RowValueType = PivotGridValueType.Total Then
    cell.BackColor = Color.Blue

how-to-format-cells-via-events-e1893/VB/ASPxPivotGrid_FormattingCellsViaEvents/Default.aspx.vb#L14

     ByVal e As PivotCellDisplayTextEventArgs)
If e.RowValueType <> PivotGridValueType.GrandTotal OrElse _
          e.ColumnValueType = PivotGridValueType.GrandTotal Then

C#

how-to-create-a-custom-chart-data-source-e2520/CS/CustomChartDataSourceWin/CustomChartDataSource.cs#L72

switch (cell.ColumnValueType) {
    case PivotGridValueType.CustomTotal:
        return result.AppendFormat(" Total ({0})", cell.ColumnCustomTotal.SummaryType).ToString();

aspxpivotgrid-how-to-provide-custom-cell-appearance-t590081/CS/CellAppearanceCustomization/Default.aspx.cs#L13

if(e.RowIndex % 2 == 0) return;
if(e.ColumnValueType == PivotGridValueType.Value && e.RowValueType == PivotGridValueType.Value)
    e.CellStyle.BackColor = Color.FromArgb(240, 240, 240);

how-to-customize-cell-appearance-via-templates-e1870/CS/ASPxPivotGrid_CellTemplates/Default.aspx.cs#L35

if (templateContainer.Item.RowValueType ==
             PivotGridValueType.Total)
    cell.BackColor = Color.Blue;

how-to-format-cells-via-events-e1893/CS/ASPxPivotGrid_FormattingCellsViaEvents/Default.aspx.cs#L11

protected void CustomCellDisplayText(object sender, PivotCellDisplayTextEventArgs e) {
    if (e.RowValueType != PivotGridValueType.GrandTotal ||
        e.ColumnValueType == PivotGridValueType.GrandTotal) return;

how-to-avoid-production-of-unnecessary-column-and-merging-of-cells-in-excel-export-e2346/CS/WindowsApplication53/Form1.cs#L81

if (e.Field != null && e.Field.Name == "fieldExportHeader" && e.ValueType == PivotGridValueType.Value )
{