We are building a report to show progress of document reviews by project. Each project can have a variety of documents and each document will go through any number of reviews, each review counting the number of Major/Minor/Advisory issues. What we'd like to show is a trend against each review, up/down/unchanged against the previous review, I just can't figure out the how or what to code.
There are 2 tables, Projects and Reviews
Projects is a simple table, Project ID, Name, Owner, Start Date and Finish Date
Reviews has more detail, Project ID, Document Name, Review Cycle(whole number), Major/Minor/Advisory issue total (whole number). Ideally as the review cycle increases the numbers of issues should decrease, but could increase, e.g. if a Major becomes a Minor or Advisory.
The trend I'm happy to be guided on, be it conditional formatting, up/down/horizontal arrows, whatever works best.
| Project ID | Document Name | Review Cycle | Major issues | Minor issues | Advisory issues |
| PRJ2233 | BRD | 1 | 2 | 2 | 2 |
| PRJ2233 | Process Maps | 1 | 2 | 1 | 1 |
| PRJ2244 | Details Requirements Doc 1 | 1 | 2 | 2 | 2 |
| PRJ2244 | Details Requirement Docs 1 | 2 | 3 | 1 | 3 |
| PRJ2244 | Details Requirements Doc 1 | 3 | 1 | 1 | 1 |
| PRJ3344 | Details Requirements Doc 1 | 1 | 5 | 0 | 1 |
| PRJ3344 | RTM Doc 1 | 1 | 4 | 6 | 0 |
| PRJ3355 | RTM Doc 1 | 1 | 1 | 1 | 1 |
| PRJ3355 | RTM Doc 1 | 2 | 6 | 7 | 0 |
| PRJ3355 | RTM Doc 1 | 3 | 5 | 7 | 9 |
| PRJ3355 | RTM Doc 1 | 4 | 0 | 0 | 0 |
| PRJ3366 | Detail requirements | 1 | 1 | 1 | 1 |
| PRJ4433 | RTM Doc 1 | 1 | 3 | 6 | 9 |
| PRJ4433 | RTM Doc 1 | 2 | 22 | 3 | 6 |
| PRJ4433 | RTM Doc 1 | 3 | 6 | 7 | 8 |
| PRJ4455 | Detail requirements Doc 1 | 1 | 2 | 1 | 1 |
| PRJ4455 | Detail requirements Doc 1 | 2 | 1 | 1 | 2 |
| PRJ4466 | RTM | 1 | 2 | 1 | 1 |
| PRJ4466 | RTM | 2 | 1 | 1 | 1 |
| PRJ4466 | RTM | 3 | 2 | 2 | 2 |
| PRJ4477 | RTM | 1 | 1 | 1 | 1 |
| PRJ4477 | RTM | 2 | 2 | 2 | 2 |
| PRJ4477 | RTM | 3 | 2 | 1 | 4 |
| | | | | | |
| Project ID | Project Name | Assigned to | Start Date | End Date |
| PRJ2233 | KOO PROJECT | Darren | 03/01/2022 | 28/01/2022 |
| PRJ2244 | KASPA PROJECT | Kojo | 10/01/2022 | 17/02/2022 |
| PRJ3344 | SINT PROJECT | Darren | 01/02/2022 | 25/02/2022 |
| PRJ4433 | COOPSEWOOD PROJECT | Darren;Kojo | 01/03/2022 | 31/03/2022 |
| PRJ2255 | KUMAWOOD | Kojo | 03/01/2022 | |
| PRJ3377 | DANNY PROJECT | Darren | 01/02/2022 | |
| PRJ3355 | Lemax project | Darren | 07/02/2022 | 24/03/2022 |
| PRJ3366 | APIE PROJECT | Darren | 07/02/2022 | 24/02/2022 |
| PRJ4466 | AB OROJECT | Darren | 01/03/2022 | |
| PRJ4477 | CD PROJECT | Darren | 07/03/2022 | 18/03/2022 |
| PRJ4455 | DE PROJECT | Darren | 01/03/2022 | |
| | | | | |
