I have a report that lists employee hours in a particular date range. The report sorts by employee ID, then a field called BU, then by a product ID. What I'd like to see is only a total in the BU line if the BU field is empty and ignore the product ID items (but still have the hours calculated in the BU line). Is this possible?
What I see:
What I'd like to see: