I am attempting to create a KPI-Categorical chart that will go into a map, but when I create the calculated field it stated that it's valid, but only has one category listed. What am i doing wrong???
As far as I can tell, your logic is correct. I recreated your issue in excel and got the expected results. It looks like you have a table calculation in your count. Perhaps you can try dragging that in instead of the [Engaged in Employment].
Retrieving data ...