I have a pivot table containing projects by departments with dollars for each
month of the year. To the right of the table, I have formulas to identify
project category based on the project ID in the pivot table rows. Is there a
way to combine these two into one pivot table? Or some other way to combine
the two, so I can sort and report project category?

Thanks much.