ContributionsMost RecentMost LikesSolutionsRe: Using totals in reportsAnd thank you, Don, for your idea about PowerBI and Tableau - I haven't heard of either of those before. Where could I find more information about PowerBI and how it connects to Quick Base? And about doing an extract? Those types of things sound like they'll be very helpful for the types of apps I'd like to develop for the company I work for. Really appreciate the help you and Mark have given! ------------------------------ Rob Reiterman ------------------------------ Re: Using totals in reportsHi Mark, Thanks for your guidance! Using your approach, I can also summarize by months and find the percent of trucks turned each month. Quite a different way of thinking than with MS Access - I can see the need to think through some things pretty carefully when designing an app in QuickBase - with Access' querys it's easy to get a bit sloppy in one's designing. Really appreciate the quick response! Thank you ------------------------------ Rob Reiterman ------------------------------ Using totals in reportsI've dabbled in Microsoft Access for many years and am used to their Querys. I'm having a dickens of a time figuring out how to do similar things in Quick Base. I have a table that contains 3 fields: - Date - # of trucks here - #of trucks serviced I'd like a report that summarizes everything by week, showing the total number of trucks that were here each week, the total number of trucks that were serviced each week, and then the percent of trucks that were serviced each week ([Total Number Serviced]/[Total Number Here]) I've figured out how to generate a 6-digit number for each date (yyyyww) showing the year and weeknumber in that year. Using that yyyyww number, I can create a report showing the number of trucks here and serviced for each of those weeks (those are totals generated by the report). Where I'm stuck is figuring out how to come up with the percentage of trucks serviced each week. Help! ------------------------------ Rob Reiterman ------------------------------