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.

For å bruke denne funksjonen …

Velg Data → Gruppe og disposisjon → Vis detaljer


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.

Supporter oss!