Download REPORTSNOW DESIGNER TRAINING GUIDE

Transcript
ReportsNow Designer Training
1/8/2013
Group Row Index
• The new column created by the Group Row Index counts
each row in the group and begins again with 1 when the
group changes
• This calculation is useful to eliminate duplicate records, first
sort the grouped data for the desired row on the top of the
group and filter by 1 to show only one row
• Example below, there is a Group Row Index on the Address
Number Description column. The Group Row Index is
filtered to 1 to get one line per Address Number. Note we
also sorted by Effective Date to get the most recent address.
Copyright 2012 iLearnERP
166