Reporting and Analysis
for GoldMine CRM and QuoteWerks quote management
Support Center > Knowledge base> Article: How do I add or hide subtotals?

How do I add or hide subtotals?

Article ID: 31827

Question
How do I add or hide subtotals?

Answer

To add subtotals to a PivotTable report:

1. Drag at least two fields to the Row area that is left of the Data area).
2. Double-click the left Row field's gray title; (see Years gray button in cell A6).

The PivotTable Field dialog box has three option buttons:

? Automatic: Excel uses the SUM formula as the default when inserting subtotals.
? Custom: Selecting this option allows the insertion of one or more formulas.
? None: Displays the PivotTable report without subtotals.

 

Screenshot

"

related articles

Article Details
Views: 298 Created on: Nov 15, 2016

Please let us know what you think of this article.
Poor
Outstanding