Originally Posted by Roger Govier

Hi Michael




Doing a double mouse click on the PT cell which is the intersection of Red
and Car, will open up a new Sheet in the Workbook with just the lines from
your main data table that match the criteria.

This sheet can be deleted after use if no longer required.

Regards

Roger Govier


michaelp wrote:
I have a table with several 100 enters and the pivot table allows me to
create sum of the totals of the data. is it possible to create a
filter from the pivot table results to then filter all the data. To
only show the items relating to the pivot table.


So if I Choose red and car in my pivot table in sheet one
In sheet two where my data is it is not only showing the line of data
with red cars in it.


Thank you