I have an Interval for Part Codes. It works correctly and will show the correct code if a Date within that interval (Transaction/Count) is available
Here is an example of a part, that has three intervals.
| PartNumber | FromDate | ToDate | ChangeCode |
| 13845 | 1/15/2017 | 3/9/2017 | C |
| 13845 | 10/15/2016 | 1/15/2017 | B |
| 13845 | 10/4/2015 | 10/15/2016 | NA |
I then have two "Transactions" or Counts of the part that I can show what the ChangeCode was for that specific Count date.
| Counted | ABC Code when counted |
| 3/24/2016 | NA |
| 10/26/2016 | B |
But NOW I need to show what that code was for each Quarter for the Current and Prior years, even if I don't have a Count in that Quarter.
I need two tables that will display the data as shown below, but I can't figure out how to get it to work correctly.
(NOTE: Our Fiscal Year starts in October)
| Part | FY16 Q1 | FY16 Q2 | FY16 Q3 | FY16 Q4 |
| 13845 | NA | NA | NA | NA |
| Part | FY17 Q1 | FY17 Q2 | FY17 Q3 | FY17 Q4 |
| 13845 | B | C | | |
.png "crystles"){kind=avatar}
