I think you were thinking you were restricted to finding the first value, counting the records, finding the second value, counting the records, etc. You could simply have a summary field which is the count of the field. Then find all the records you are interested in analysing, sort them by that value, and include that summary value in a sub-summary part. You don't have to include any body part if you don't want to. You could show the grand total count at the bottom of the listing. You could calculate the fraction by including a calculation in the sub-summary part, say:
GetSummary ( SummaryCountOfThatValue ; ThatValueField ) / Get ( FoundCount )
If each field formatted with one or the other of your two value lists permits only one value selection....
If you want these percentages for either all the records in your table or for a found set you pull up....
You can do the following:
define constOne as a calculation field, returning the constant value: 1.
Define a summary field as fraction of total of constOne.
Create a layout to be used in List View with a sub summary part "when sorted by" your first value list formatted field. Create a second sub summary part "when sorted by" your second value list formatted field.
Put your summary field in one or both of these sub summary parts.
You can then perform a find to pull up the records you want for your report, then sort them by these two fields, to see your percentages. (Format summary field as a percent.)
If you do not want to see the individual records listed in the body, only the percentages, remove the body part from your layout.
Thanks so much for this. I appreciate the help.
Both answers are a great help. If I can't work it from here, I'll re-design the thing without value lists!