Automatically show all detail data

  1. In the design window, make sure the PivotTable list is activated. For instructions, see Help for your design program.
  2. Click the title bar of the PivotTable list.
  3. On the toolbar, click Commands and Options , and then click the Behavior tab.
  4. Set Expand details by default to Always.

Notes