Forum Discussion
Joining Tables
Hello, I have the following columns below, but I would only like to show the rows where Id=FirstProofMessageId. How do I go about doing this? These columns are from 2 seperate tables on my report...
Text please, I hate typing.
Hi Greg_Deckler,
Please see below:
vProofMessage:
| 36977 | 14000 | 9/13/2018 14:13 |
| 36977 | 14942 | 9/18/2018 16:23 |
| 36977 | 14943 | 9/18/2018 16:23 |
| 36977 | 14944 | 9/18/2018 16:24 |
| 36977 | 14974 | 9/18/2018 18:33 |
| 36977 | 15159 | 9/19/2018 16:26 |
| 36978 | 14017 | 9/13/2018 15:13 |
| 36978 | 14075 | 9/13/2018 17:42 |
| 36978 | 14102 | 9/13/2018 19:25 |
| 36978 | 14480 | 9/16/2018 13:02 |
| 36978 | 14489 | 9/17/2018 2:31 |
| 36979 | 14027 | 9/13/2018 15:53 |
vReviewOrderSLA:
| 9/13/2018 12:21 | 36976 | 14006 |
| 9/13/2018 12:44 | 36977 | 14000 |
| 9/13/2018 13:03 | 36978 | 14017 |
| 9/13/2018 13:17 | 36979 | 14027 |
| 9/13/2018 13:38 | 36980 | 14063 |
| 9/13/2018 13:44 | 36981 | 14049 |
| 9/13/2018 13:50 | 36982 | 14025 |
| 9/13/2018 13:54 | 36983 | 14018 |
| 9/13/2018 14:04 | 36984 | 14739 |
| 9/13/2018 14:31 | 36985 | 14048 |
| 9/13/2018 14:48 | 36986 | 14041 |
| 9/13/2018 14:48 | 36987 | 14079 |
Just filter the blanks from your First Proof Date measure. See attached, Page 5.