When you want to understand how a value was obtained in a cell in the pivot table, you can view details about that cell. You can view cells from the values area of the pivot table, including cells with totals and subtotals.
You can view cell details in a pivot table in one of the following ways:
•Double-click the cell with the value.
•Right-click the cell with the value to open the context menu and select Show Details.
As a result, a new sheet will be created. This sheet will generate a table with the data used to calculate the value in the cell of interest. Even though the data on the sheet can be edited, changing it will not affect the source data or the pivot table.
The table on the new sheet inherits the style of the pivot table from which it was generated. You can change the style and areas of the table in the settings on the Sidebar.
You cannot view cell details in the following cases:
•For the pivot table, the details display setting in the Options tab of the Pivot Table settings pane is disabled.
•The pivot table data has not been updated since the document was opened.
•The structure of the document is protected from changes.
•The sheet with the pivot table is protected from changes, and the option Work with pivot tables is disabled in the Allowed actions list.