I had the same problem and I opened a support ticket. Apparently, we cannot use filters or expressions for dynamic fields. Here is a response from the support team This is advanced advanced reporting but if you install the add-on json in Chrome and then add attask/api-internal/metadata to the en...

I trying to create a Matrix Hour Report. My rows are Users and the column is Entry Date (in months). The report looks okay but I would like it to sort by Total Hours i.e. I would like to sort it by user with highest number of hours to the lowest.

Thanks, this is great

Thanks Skye for responding, My challenge in "Note" report is that if there is a Task with no notes than it will not show up in my report

How can I create a report that lists tasks with its details and all its notes