lostyankee
New Member
- Joined
- Jul 14, 2019
- Messages
- 6
I have a table of data with multiple fields that I need to include to assign a classification, or "grade" to. For example, in my data, I have:
<colgroup><col><col><col span="3"></colgroup><tbody>
</tbody>
Help!
- department
- floor set date
- region
- average rate of sale
Dept | Floor Set Date | Region | Ave Rate of sales | Ranking |
123 | 5/1/2019 | North | 1.44 | A |
123 | 5/1/2019 | North | 1.44 | A |
123 | 5/1/2019 | North | 1.4 | A |
123 | 5/1/2019 | North | 1.33 | A |
123 | 5/1/2019 | North | 1.3 | A |
123 | 5/1/2019 | North | 1.29 | A |
123 | 5/1/2019 | North | 1.28 | A |
123 | 5/1/2019 | North | 1.24 | A |
123 | 5/1/2019 | North | 1.21 | A |
123 | 5/1/2019 | North | 1.15 | B |
123 | 5/1/2019 | North | 1.13 | B |
123 | 5/1/2019 | North | 1.1 | B |
123 | 5/1/2019 | North | 1.08 | B |
123 | 5/1/2019 | North | 1.08 | B |
<colgroup><col><col><col span="3"></colgroup><tbody>
</tbody>
Help!