I am generating an attribute table which may have many thousands of entries. There is a column (one of perhaps 20 or so) for 'vegetation type'. I need to generate a report (or some other easily exportable format) which automatically counts and lists how many times each vegetation type is included in the table. There's far too many entries to do manually and I will need to run the process a number of times so I'm hoping there's a way to automate the process.
For example the attribute table may look like FID COLOR 0 Red 1 Blue 2 Green 3 blue 4 blue 5 green 6 blue 7 green 8 red 9 blue 10 yellow
The report would then say something like Blue: 5 Red: 2 Green: 3 Yellow: 1 Total: 11