Dimension not displaying as expected

tableaucommunity@tableau.com — Mon, 23 Jan 2012 01:04:07 GMT

I have a dimension that I can't get to behave the way I want it to. I have tried converting it to a measure, but it just shows a count instead of the value I want. The data field is a descriptive field indicating what title/level they worked at in that particular year. There would only be one value per year. When I try to add it (as a dimension) to my table, it uses all the possible values in that field as column headers (see attached document). When I try to convert to a measure, it just counts it.

Content in Tableau Community Forums

Dimension not displaying as expected