Forum Discussion

MrunaliKadam's avatar
MrunaliKadam
Qrew Trainee
4 years ago

Table report- Need to show only most recent record per member

Hi,  I've created this table report. One person can vote multiple times and current report shows all votes submitted by each person. Need to update it to show only most recent vote per voting membe...
reports and charts
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
Assuming that you have a relationship where one member has many votes then he would make a summary field to summarize the maximum record ID of all the votes for that number. Then look up that maximum record ID down to the trial table and filter the report so that you only show where the record ID of the vote record is equal to the maximum record ID.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------