I have a field named Funding that uses a value list from another file, and the value list is displayed as 15 checkboxes. The value list in the other file can be edited, so it can change over time.
I want to create a summary report counting the number of times a value appears in Funding.
For example, I may have data like this:
My summary report would look like this:
I tried to create a sub-summary report with Funding and a summary field that was a Count of the Funding field. This works great counting the total amount of records using the Funding field, but I cannot figure out how to create a summary for each individual value. To further complicate things, the value list that creates the checkboxes will change over time, so I cannot rely on the value list to return all possible values entered into the field. I need to be able to support historical reporting, so I need to be able to report on all possible values in the Funding field.
Can anyone give me any guidance to approach this dilemma? I'd prefer not to change the schema or the implementation of the Funding field.