I have 10 fields in my table that represent year 1-year 10. I want to group a report by the year represented in the field, not by the field itself. For example, one result may look like this:
...and so on
The next result may be:
I want to...
So when I say it is "simple", I meant that there is only one table and no table joins happening. The table I am pulling from has 100+ fields of varying field type (string, number, datetime). However, this report only concerns string and number fields...