Creates a new PivotTable report for each item in the page field. Each new report is created on a new worksheet.
Syntax
expression.ShowPages(PageField)
expression Required. An expression that returns a PivotTable object.
PageField Optional Variant. A string that names a single page field in the report.
Remarks
This method isn’t available for OLAP data sources.