My original table in ArcMap is associated with polygons. In some cases, a polygon can have two records but with different values for each record.
I can summarize the table based on unique value of each polygon as well as get the max value from the polygon - but I would also like to bring along the associated attributes with the max record in the summary. Is there a way to do this in ArcMap or any other database/spreadsheet program.
UniquePoly Yield Crop Number of Acres 1 100 Wheat 125 1 75 Canola 60
My summary table would be:
UniquePoly MaxAcres CountofUniquePoly 1 125 2
But I also like to carry across the yield and crop in the summary table
UniquePoly MaxAcres Count Yield Crop 1 125 2 100 Wheat