I have a need to produce a list of the # hours worked by month my manager. The data model has a cross table of Month and Hours Worked and has Resource Name and Manager as dimensions. I want to produce a list by manager only if one of their resources has > 100 hrs in one of the 12 months. Any ideas?
