I have a data model that shows Counts of Parts and the date the part was counted. We have different classifications of parts (A,B, and C). However, The system will change the category of the part (based on some other criteria, but it's not important to this issue).
I have the current ABC_Code for each part in another table
That table that is created from the database that checks if the ABC_Code has changed, at the beginning of each Quarter. If the code has changed, it lists the part number and the new and old code.
So this table would have ....
Part Number = 123
Old Code = A
New Code = B
Date of Report = 1/1/17 (beginning of quarter, so the New code will need to be applied to this part for the future quarters going forward, unless a new change is made, in any following Yearly Quarters)
The problem is, they want a chart to look like the chart below in the QV document I have for them.
I only have the date the code changed (if it ever changed at all) with the new and old codes, the current code for each part,and the date the part was counted. I do not have a code for each Quarter, so I (think) I am going to have to "create" these codes for each Quarter in order to show the codes for each year/quarter.... I'm not sure how to do that.... Or at least what the "best" way to do that would be...
Any help would be greatly appreciated. Thanks!
| Part Number | Q1 | Q2 | Q3 | Q4 | # of counts |
|---|
| 123 | A | A | A | A | 6 |
| 124 | C | C | B | A | 8 |
| 125 | C | C | B | B | 1 |
| 126 | (Blank) | (Blank) | C | A | 4 |
.png "crystles"){kind=avatar}
