I have this pivot table:
Capture.PNG
In between columns B and C, I'd like to insert a column that counts Employee Names in column C grouped by column B.
For example, in the picture above, Senior Consultant April will have the number 8 - a count of employees under her.
Can I create this custom field in the pivot? Or will I have to engineer a formula to do so outside of the pivot table?
1.PNG
Bookmarks