You can see the related source data displayed on a new
sheet by double-clicking one of the cells in the DataPilot table.
To open the new sheet containing the related source data
in the DataPilot table, perform the following steps:
- Select a DataPilot table.
- Right-click the DataPilot table, and select DataPilot
Table Option.
- Select Enable drill to details and
click OK.
- Double click one of the cell in different area, there are
different output.
- Double click a cell in a row or column, and the subtotal
for the same category is displayed. Other rows or columns are hidden
in the DataPilot table.
- Double-click the cell in a data area and a new sheet
is created before the current DataPilot table. This sheet contains
the related source data. If you are using a filter in the DataPilot
table, the detailed data in the new sheet does not include the data
that is excluded by the filter rule.