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

• To hide detail data for all items, select Never in the Expand details by default list. If you set Expand details by default to Automatic, data from tabular sources will be expanded by default, but data from OLAP databases will be hidden.
• To automatically show all items in a PivotTable list, on the Behavior tab, set Expand items by default to Always.
• Detail data usually is not available for display in PivotTable lists that are based on source data from OLAP databases. If detail data is not available, changing the Expand details by default setting has no effect.