This already exists. The field should be set up as a Single-select dropdown or Radio button rather than a Checkbox group. 

Thank you! This session was awesome. By any chance, do you have the Word Document Template that was used during this workshop to share? 

Awesome! Glad I could help 

I've done this by creating an Assignment report then:Put a distinct count on the Project name fieldaggregator.displayformat=val aggregator.function=DCNT aggregator.namekey=project:name aggregator.valuefield=project:name aggregator.valueformat=val displayname= linkedname=project namekey=view.relatedc...

Ahh this is perfect and now works great! THANK YOU! 

Thanks, @Sven-iX. It worked, but only if grouped by hour type. Is there a way to do it so it shows the sum per column at the owner grouping and not have to group by hour type to show the sum like in the attached screenshot?  

I created an hours report that breaks down hours by hour type in separate columns. Is it possible to sum each column? I tried the following but it gives me a sum of all the hours, not just the "X40" hours I'm filtering for. aggregator.displayformat=doubleAsIntaggregator.function=SUMaggregator.nameke...

I have a Billing Record report that I want to sort by project total billed amount (highest to lowest). There may be more than one billing record per project. I have the report grouped by Project Reference number and showing a sum of the amounts. The report is currently sorting in descending order on...

I would like to see this as well. The billing record report allows you to see the total amount and other amount as columns, but not the billable hours or billable expenses. It would help to see these broken out.

The issue is when trying to add hours to the billing record. You can add hours and it allows you to select the hours you want to include in the billing record. The billing record shows the correct amount when we save it, but when you go back in, there are NO hours pulled in. There is an error messag...