Hi! I apologize if this has been covered, but I cannot seem to get my desired end result--
I have a table set up with counties on the left, and impact types on top as columns. 4 out of 5 columns are dollars, but I want one column to simply be units. Is this possible to do without creating another field?
This can be possible with the dollars field as a dimension. But this loses some additional functionality though.
You can write a calculated field as
IF ImpactType <>'5th column' then '$'+STR([Dollar Field])