Cross Tab and Count New Values

Question

Hi all - I have a list of projects (Key field) with their current status and the manager tagged to it (sample below). I'm looking to group by manager and get a count of each phase of the status field so you can see how many projects are in each phase per manager. I tried to cross tab then take a count with the summarize tool but I do not get an accurate output. Any assistance to get the desired output is appreciated.

AngelosPachis · Accepted Answer

Hi @727 ,

If I understand the requirements correctly, maybe you can try using a summarize tool? So group by Mgr and Status and count the Key Field?

That will give you how many projects (keys) each manager has under each status.

Hope that helps,

Angelos