ACC2002: PivotTable List Displays "No Totals" or "No Details" in Data Area (301379)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q301379
Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SYMPTOMS

When you are working with an object in PivotTable view, the PivotTable list displays an empty cell with the title No Totals or No Details in the Drop Totals or Detail Fields Here area.

CAUSE

This behavior occurs under the following situations:
  • The data axis of the PivotTable list contains no fields in Details view, while the data axis contains totals in Totals view.

    -or-
  • The data axis of the PivotTable list contains no totals in Totals view, while the data axis contains fields in Details view.

RESOLUTION

To prevent the PivotTable list from displaying No Totals, add one or more totals to the data axis of the Totals view of the PivotTable list. To add totals to the data axis of the Totals view of the PivotTable list, follow these steps:
  1. Open the object in PivotTable view.
  2. On the PivotTable menu, click Show Details so that the PivotTable displays the data axis in Details view.
  3. On the View menu, click Field List to display the PivotTable field list.
  4. Drag the fields that you want to total from the field list to the data axis. The fields will automatically display the detail data from the underlying table or query.
  5. Select the columns in the PivotTable list that contains the data for the fields that you added in step 4.
  6. On the PivotTable menu, point to AutoCalc, and then click the aggregate function that you want to use for the total. Note that the intersection of each column and row displays a subtotal for the detail field.
  7. On the PivotTable menu, click Hide Details.
Note that the PivotTable list displays the totals that you selected in step 6 and no longer displays the empty cell named No Totals.

To prevent the PivotTable list from displaying No Details, add one or more fields to the data axis of the Details view of the PivotTable list. To add fields to the data axis of the Details view of the PivotTable list, follow these steps:
  1. Open the object in PivotTable view.
  2. On the PivotTable menu, click Show Details so that the PivotTable list displays the data axis in Details view.
  3. On the View menu, click Field List to display the PivotTable field list.
  4. Drag one or more fields to the data axis.
Note that the empty cell named No Details disappears, and that the PivotTable list displays detail data within the data axis.

STATUS

This behavior is by design.

MORE INFORMATION

There are two distinct views for objects in PivotTable view. The first view is Details view, which causes the PivotTable list to display detail data (and optionally subtotals) from the underlying table or query. The second view is Totals view, which causes the PivotTable list to hide detail data, and to display only totals (such as sums, counts, and averages) of fields from the underlying table or query.

The data axes for both views are mutually exclusive. In other words, it is possible for the data axis in Details view to contain one set of fields, and the data axis in Totals view to contain a different set of fields (or no fields at all). When one view contains fields in the data axis and the other view does not, the PivotTable view will display either No Totals or No Details, depending on the current view.

For example, the PivotTable view will display No Totals under these circumstances:
  • You opened an object in PivotTable view.
  • You added one or more fields to the data axis of the PivotTable list while the PivotTable list was in Details view.
  • You switched the PivotTable view to Totals view by selecting the Hide Details command on the PivotTable menu, but you did not yet add any totals to the data axis of the PivotTable list.
Likewise, the PivotTable view will display No Details under these circumstances:
  • You opened an object in PivotTable view.
  • You switched the PivotTable view to Totals view by selecting the Hide Details command on the PivotTable menu.
  • You added or more totals to the data axis of the PivotTable list while the PivotTable view was in Totals view.
  • You switched the PivotTable list to Details view by selecting the Show Details command on the PivotTable menu.

Steps to Reproduce the Behavior

CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.

  1. Open the sample database Northwind.mdb.
  2. Close the Main Switchboard form if it appears.
  3. On the View menu, point to Database Objects, and then click Tables.
  4. Click the Orders table, and then click Open to open the table in Datasheet view.
  5. On the View menu, click PivotTable View. This changes the Orders table to PivotTable view and displays an empty PivotTable.
  6. On the PivotTable menu, click Hide Details. This causes the PivotTable list to display only totals or summary data.
  7. On the View menu, click Field List to verify that the PivotTable field list is showing.
  8. From the PivotTable Field List, drag the Freight field to the Drop Totals or Detail Fields Here area.
Note that the data axis displays an empty cell with the title No Totals.
Modification Type:MajorLast Reviewed:9/27/2003
Keywords:kbprb KB301379
©2003 Microsoft Corporation. All rights reserved.