Note: This article has done its job, and will be retiring soon. To prevent "Page not found" woes, we're removing links we know about. If you've created links to this page, please remove them, and together we'll keep the web connected.
If the workbook that you have contains a PivotTable report, you can expand or collapse to any level of data detail. For example, if you see data at a country/region level, you can expand to a state level, and down to a city level.
Note: Although the expand and collapse buttons are usually turned on by default, the workbook author may have turned off the expand and collapse buttons.
On a field, click the expand or collapse button.