Assume you have a total of 100 items and a multi-select field that allows you to select from a set of values. You want to find out what percentage of the total is represented by the selected values.
Could you provide an example of this and what you would want the output to be? For example, is the data in the screenshot below set up the way you expect? If it is, what would some examples of output be?
Use a "reporter" field. This is a linked record to a new table called reporter. Each one of your items will link to "reporter." In reporter you can use a "count" field to count the items that use select A, select B, etc. as a percent of the total.