property Pivot.ShowDataOnDblClick as Boolean
Specifies whether the user shows the original data that generated the result when user double clicks a cell.

TypeDescription
Boolean A boolean expression that specifies whether the data that generated the result is shown once the user double click the cell.
By default, the ShowDataOnDblClick property is False. Use the ShowDataOnDblClick property on True, to let the user to display the data that generated the result when a cell is double clicked. For instance, you double click a cell and the list will be filled with the data that generated the result being double clicked. Use the ExpandOnDblClick property to expand an item once the user double clicks the item. The same property allows you to display more data if the user double clicks a ... row, while the DisplayPivotData property is positive.

The following screen shot shows the data before double clicking the red cell ( Speedy Express/Salzburg/Austria ):

The following screen shot shows the data that generated the result ( 6 ) after double clicking the red cell ( Speedy Express/Salzburg/Austria ):

As you can see, the list displays only the data of Speedy Express/Salzburg/Austria, so a 6 rows.