I'm trying to produce a map with different categories based on four columns (lag, mlag, mhog and hog), these are income status. I want each polygon in the map to be represented by whatever number who is the highest among these four columns, thus making it a map with four different categories that represent the most prevalent income in that area.
I.e. for FID 0 it will be 'hog'
I figure it must be something related to Symbology but there is no option to select categories based upon highest number or something like it.
I hope I was clear enough, the task is quite simple I think but I can't really see right now how I should do it.