Get only data on PivotTable

[mrchonginhk]

If I double click Grand total on PivotTable I get all columns of data including those not on the PivotTable.
Is there way to get the data only for dimensions that appear in the PivotTable only ?

Thanks

 

[mrchonginhk]

any one know the answer