Here is a fairly low-tech proposal.
1. Produce a second unfiltered pivot table which could be hidden out of sight if desired
2. Next to the second pivot table populate the corresponding first cell using: =MATCH(S4,A$4:A$23,0) and double click the fill handle to copy down
3. The list of filtered samples is displayed using: =IFERROR(INDEX(S$4:S$22,AGGREGATE(15,6,(ROW(S$4:S$22)-ROW(S$3))/(ISERROR(T$4:T$22)),ROWS(D$1:D1))),"")
Let us know if you have any questions.
Bookmarks