Forum Discussion
Creating a heirarchy in a hierarchy using IDs based on range of values between in it.
We have data for which hierarchy is defined within it and we need to categorised the data based on the range. So for example, 100000-299999 is the main hierarchy in it we have 120000-129999, ...
Based on the numbers and colours highlighted I want to create a column of category that says which category these numbers belong to depending on the levels.
Your color assignments do not follow any discernable logic. You will need to use a manual mapping table.