I have data represented in the following manner

Status Date Proj # Team A Team B
TeamC
O 7/1 aa REJ - 7/2
APP-7/4 WAIT - 7/2
O 7/3 bb APP-7/4 REJ -
7/8 REJ - 7/7
C 6/3 cc APp-7/9 REJ -
7/6 APP - 79

Above is an example, but I have more fields and more team data, I would
like to run a report that lets me sort through open/close status or date or
proj # and the response by teams, and shows the text.

I know I can do filters and sort for that the problem is that I have about
50 teams. I want a repeatable way to be able to see every column that has a
reject, or wait as a status for the teams, status and certain date criteria.

Pivots are only doing counts/sums etc, but I want to show the data in that
text not count them.

Filters are not working either in this case as we drill further down so ....

any help would be apprciated.