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