Qilan® Project Examples

This is a very simple example of how summary counts can be performed. The records in the Company table are subgrouped by State with a count of how many records are in each state. The sort is based on the subgrouping. The 'running total' demonstrates how values can be incremented as each subgrouping is iterated (looped).

State	Count	Running Total
AK	6	6
AL	3	9
AR	3	12
AZ	5	17
CA	6	23
CO	5	28
CT	4	32
DE	4	36
FL	4	40
GA	4	44
HA	5	49
IA	4	53
ID	4	57
IL	4	61
IN	3	64
jpbpatRiwrgBVc	1	65
KS	4	69
KY	5	74
LA	3	77
MA	1	78
MD	3	81
ME	5	86
MI	6	92
MN	4	96
MO	5	101
MS	3	104
MT	3	107
NC	3	110
ND	4	114
NE	4	118
NH	5	123
NJ	3	126
NM	2	128
NV	4	132
NY	5	137
OH	4	141
OK	3	144
OR	5	149
PA	3	152
RI	3	155
SC	5	160
SD	2	162
TN	4	166
TX	6	172
UT	4	176
VA	4	180
VT	4	184
WA	4	188
WI	4	192
WV	3	195
WY	3	198