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