I am creating a dashboard so that our designers have a quick & dirty way to look at project info without looking through all of the Project Details. Currently this is being done with a Project report that has key information on it. I want to be able to show them the total number of hours that have been worked by all people on the project that have a specific Job Role ("Graphic Designer" in this case.)
I'm using shared columns to make this, so I think I need to generate a new calculated field to be able to see this correctly. However, if I have to abandon shared columns for in-report valueexpressions in Text Mode I'm okay with that. An example of what I currently have:
The Quoted Hours are filled in from other fields, and the Actual Hours total is just the actualWorkRequired. But separating that total into two different totals based on Job Role is what I'm after. I hope this is possible! Any advice would be appreciated on how to approach this.