Show Details (Pivot Table)

Inserts a new "drill-down" sheet with more information about the current pivot table cell. You can also double-click a pivot table cell to insert the "drill-down" sheet. The new sheet shows a subset of rows from the original data source that constitutes the result data displayed in the current cell.

Lai piekļūtu šai komandai...

Choose Data - Group and Outline - Show Details (for some pivot tables).

Piezīmes ikona

Hidden items are not evaluated, the rows for the hidden items are included. Show Details is available only for pivot tables that are based on cell ranges or database data.

Please support us!