Please see my other Database Development articles.
Often, recordsets contain values that naturally reveal metrics that provide helpful insight into the data.
In this example, I list records about people. Each record contains information about a person’s age, gender and name.
First, I list each person’s age, the sum of all peoples’ ages, then their age as a percentage compared against the total of all ages.
Here is the final resultset.