ContributionsMost RecentMost LikesSolutionsRe: highlight most recent entry in group on reportThank you so much, IDS (I didn't catch your name) - You are awesome!Re: highlight most recent entry in group on reportIt really needs to be based on that date field.....Re: highlight most recent entry in group on reportWell I tried that, and it was checking the box on dates that are earlier than the latest update... Re: highlight most recent entry in group on reportMy key field is not the Record ID - it is the Manager ID....highlight most recent entry in group on reportI am trying to see if it is possible to highlight or conditionally format the most recent entry on a report_in each group_ - so if the report is grouped by Manager ID, and shows several updates per manager (see below), I want the latest entry to be a different color or highlighted ID Date Update notes 1234 _1234 7/10/19 update here notes and such 1234 7/1/19 another update here more notes 1234 6/15/19 another one blah blah _5678_ 5678 7/9/19 update and what not some notes 5678 7/5/19 here is an update note note note 5678 5/15/19 again with an update notes and notes and notes So the first lines for each ID would be highlighted (the one on 7/10/19 for 1234 and the one on 7/9/19 for 5678) Please help!! And thanks in advance :)Re: how to create crosstab reportYes, that is what I am trying - but it only lets me choose one field to group by - as you can see, I need to group by 3 different fields, and they are "nested" If it is possible to create this in either report option, please provide some more specific instructions? Because I am NOT getting it on my ownhow to create crosstab reportI need help creating a cross tab report - below is an example of how i need the data to lay out - I am just not wrapping my head around how to create the report in quickbase - HELP!! Re: formula to total then divide fieldOK so yes, I still need help with this concept.....Re: formula to total then divide fieldMark, Thank you so much for your help so far - can you give me an example, or point me to an example of using the single record .. i've seen it described before, but I really want to finally understand it and make it work :)Re: formula to total then divide fieldWell it could be by week, or by month ... or by day I suppose. And they want to be able to choose the date range they are viewing. So if it's a report showing grouped by week, then it would only show the weeks they choose in a filter. So daily, obviously my number is correct - when I start trying to group or summarize by week or by month, that is when the number doesn't calculate properly. and it is MADDENING at this point. OMG so freaking easy!!! We are trying to AVOID excel and promote the use of QB and things like this are exactly why people avoid it and keep emailing version 2389 of a spreadsheet that has grown to 934,012 records - some of which may or may not have been updated in the last version. and just FYI - the numbers can change - so i'll be updating them probably weekly (So it's not like I can get several weeks worth of #s figured out in excel and then just import them into a table... the calculation needs to be performed and WORKING directly in the report. There HAS To be a way to do this!!