PivotSection (Object)

Member of:

Sections collection

Description:

Represents a Pivot section.

Example:

Example:

This example shows how to modify the top and side labels on a pivot and create a chart based on the new pivot:

with(ActiveDocument.Sections["Pivot"])
{
          TopLabels.Add("Year")
          SideLabels.Add("Winery")
          ChartThisPivot()
}

Methods:

Activate(), ChartThisPivot() As ChartSection, Copy(), Duplicate(), Export(Filename As String, [optional] FileFormat As BqExportFileFormat, [optional] IncludeHeaders As Boolean, [optional] Prompt As Boolean), ExportToStream([optional] Filename as String, [optional] FileFormat as BqExportFileFormat, [optional] IncludeHeaders as Boolean, [optional] DataStreaming as Boolean, [optional] Prompt as Boolean, PrintOut([optional] FromPage As Number, [optional] ToPage As Number, [optional] Copies As Number, [optional] Filename As String, [optional] Prompt As Boolean), Recalculate(), RefreshDataNow(), Remove()

Properties:

Read-only: Property Active As Boolean, Property LastPrinted as Date, Property Type As BqSectionType

Read-write: Property CSSExport as Boolean, Property EnableNullFactsInComputedItems as Boolean, Property ExportWithoutQuotes as Boolean, Property HTMLExportBreakColumnCount as Number, Property HTMLExportBreakRowCount as Number, Property HTMLHorizontalPageBreakEnabled as Boolean, Property HTMLHorizontalPageBreakUnits as BqHTMLPageBreakUnits, Property HTMLVerticalPageBreakEnabled as Boolean, HTMLVerticalPageBreakUnits as BqHTMLPageBreakUnits, Property Name As String, Property RefreshData as BqRefreshData, Property ShowOutliner As Boolean, Property ShowSortLine as BooleanProperty SurfaceValues As Boolean, Property TrueComputedItemTotals as Boolean, Property Visible As Boolean

Collections:

Events as Events, Facts As PivotFacts, SideLabels As PivotLabels, TopLabels As PivotLabels, UserValues as UserValues

Objects:

DataLabels As DataLabels, CornerLabels As CornerLabels,