Hiding Subtotals

3 Sep 20203 minutes to read

The pivot grid control provides support to show or hide its subtotal values. This support allows users to have an abstract view of the data. The following levels of hiding are supported in the pivot grid control.

  • Hiding all the subtotals.
  • Hiding only the row subtotals.
  • Hiding only the column subtotals.
  • Hiding the subtotals for the specific pivot item.

Hiding all the subtotals

The subtotal values of both pivot rows and pivot columns can be hidden by using the ShowSubTotals property. Refer to the following code sample to hide all the subtotal values in the pivot grid.

<pivotGrid:SfPivotGrid x:Name="pivotGrid1" ItemSource="{Binding ProductSalesData}" ShowSubTotals="False">
</pivotGrid:SfPivotGrid>
this.pivotGrid1.ShowSubTotals = false;
Me.pivotGrid1.ShowSubTotals = False

Hiding-Sub-Totals_image1

Hiding only the row subtotals

The subtotal values of pivot rows can only be hidden by using the ShowRowSubTotals property. Refer to the following code sample to hide only the subtotal values of pivot rows in the pivot grid.

<pivotGrid:SfPivotGrid x:Name="pivotGrid1" ItemSource="{Binding ProductSalesData}" ShowRowSubTotals="False">
</pivotGrid:SfPivotGrid>
this.pivotGrid1.ShowRowSubTotals = false;
Me.pivotGrid1.ShowRowSubTotals = False

Hiding-Sub-Totals_image2

Hiding only the column subtotals

The subtotal values of pivot columns can only be hidden by using the ShowColumnSubTotals property. Refer to the following code sample to hide only the subtotal values of pivot columns in the pivot grid.

<pivotGrid:SfPivotGrid x:Name="pivotGrid1" ItemSource="{Binding ProductSalesData}" ShowColumnSubTotals="False">
</pivotGrid:SfPivotGrid>
this.pivotGrid1.ShowColumnSubTotals = false;
Me.pivotGrid1.ShowColumnSubTotals = False

Hiding-Sub-Totals_image3

Hiding the subtotals for specific pivot item

This can be achieved by setting the ShowSubTotal property to false for the specific pivot item. Refer to the following code sample to hide the subtotal values of “Date” pivot item.

NOTE

If the ShowSubTotals property of pivot grid control is set to false, then hiding the subtotals of specific pivot item will do nothing.

<pivotitem:PivotItem FieldHeader="Date" FieldMappingName="Date" TotalHeader="Total" ShowSubTotal="False"/>
this.pivotGrid1.PivotRows.Add(new PivotItem { FieldHeader = "Date", FieldMappingName = "Date", TotalHeader = "Total", ShowSubTotal = false });
pivotGrid.PivotRows.Add(New PivotItem() With { _
    Key .FieldHeader = "Date", _
    Key .FieldMappingName = "Date", _
    Key .TotalHeader = "Total", _
    Key .ShowSubTotal = False _
})

Hiding-Sub-Totals_image4

A demo sample is available in the following location.

{System Drive}:\Users\Public\Documents\Syncfusion\Universal Windows<Version Number>\SampleBrowser\PivotGrid\PivotGrid\View\TotalsHiding.xaml