This option does not apply to Pivot Charts and any formatting changes will be lost when the chart is refreshed. Preserve formatting - Retains any formatting you apply to a PivotTable report when the data is refreshed or the layout changes. This option is not available in PivotChart reports. Merge labels - Select to merge cells for all outer row and column labels in the PivotTable report. This option is not available in reports based on source data from OLAP databases. In a PivotChart report, the subtotals are affected in the associated PivotTable report. Subtotal hidden page items - Includes hidden page field items in Pivot Table report subtotals. Use the Format Report command on the PivotTable toolbar to apply a different autoformat to your PivotTable report. In a PivotChart report, the grand totals are displayed in the associated PivotTable report.Īutoformat table - Applies the default Microsoft Excel autoformat to your Pivot Table report. Grand totals for rows - Displays grand totals for rows in a Pivot Table report. In a Pivot Chart report, the grand totals are displayed in the associated PivotTable report. Grand totals for columns - Displays grand totals for columns in a Pivot Table report. You can provide a name for the pivot table. In a Pivot Chart report, this box contains the name of the associated Pivot Table report, and changing it renames the Pivot Table report, not the PivotChart report. Name - Type a new name to change the name of the report.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |