Hello everyone,
I'm trying to build something similar to a crosstab because it also needs to include info that can't be summarized (assigned supervisor, staff credentials).

My table includes service hours and service code which works great in cross tab by calculating service hours for each code. I'm wondering if I can do something similar in a formula. I included a photo to help explain. For each staff, I'd like service hours for each their code 440,400,450, etc. Please help.



Edited by Andrewarbogast - 11 Jan 2018 at 6:05am