Table help

K

K

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top