Cross Tab and Count New Values

[727]

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 solution]

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

[727]

Ah I had been grouping by all three fields in the summarize tool rather than taking a count of the key field. I did this then cross tabbed and cleansed my data and got the desired output. Thank you!