I have a view that returns, amount other things, category and Hours. See attached. I would like to create another view the uses this view as input, but that adds the hours together for certain categories.
For example, see the 2 in red - "Annual: Harassment Prevention" and "Annual: ACLSA". Now there can also be records that correspond like - "Req: Harassment Prevention" and "Req: ACLSA".
I need to add together the hours of the Annual and Req records and end up with one record with combined hours and a category of "Harassment Prevention" and "ACLSA" for this example.
In general, all the records where the category begins with "Annual:" might have a corresponding record where the category begins with "Req:" and I need to combine them.