Expands the data found in a Pivot Table control according to a row header or to a column header.
// Expands all quarters
PVTExpand(PVT_Sales, COL_OrderDate_Quarter)
Syntax
PVTExpand(<Pivot Table control> , <Header to expand>)
<Pivot Table control>: Control name
Name of the Pivot Table control to be used.
<Header to expand>: Character string
Name of the row header or column header to expand.