Show All

Retrieve PivotTable or PivotChart page field data for each item or for all items

This setting is not available in reports based on OLAP source data.

1. Double-click the page field.
2. Click Advanced.
3. Specify whether you want to query the data for each page separately or all pages at once.

   • If you want to retrieve less data each time, click Query external data source as you select each page field item under Page field options. This option is useful if you are working with large external databases.

   • If you want to query less frequently, click Retrieve external data for all page field items. This option lets you change pages faster.

4. To lock a field set to query page-by-page in the page area, so that it can't be moved to the row, column, or data area, select the Disable pivoting of this field check box. This option prevents a field from being dragged to another area causing all the data to be retrieved.