Forum Discussion

DEVICECYCLE's avatar
DEVICECYCLE
Qrew Member
9 years ago

Display Latest Record in the Cross Tab Summary

I have a report that cross Tab summarize the quote of my Suppliers. However, it only displays the minimum or maximum quote. I would like for it to display the latest quote. How can I do this? ...
reports and charts
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
Kipp,
no problem,
1. Summary of the maximum date.  Call it [Most Recent Date]
2. Lookup up down to detail records.
3. Summary of Maximum Record ID subject to the extra condition that the [Record ID#] equals the value in the field [Most Recent Date].
KippKipp's avatar
KippKipp
Qrew Cadet
8 years ago
I nearly managed to replicate this and then realised the date field I am using as a reference is not so in some instances there would be more than one Record ID# for the same date. As result we are taking a different approach on this one but thank you very much for your help.