I have endemicity, implemented with an option set, as a numeric code assigned to districts. I use this data element in the maps app with a legend to produce thematic maps. Its nice. However in the pivot table I’d like to display the option name not the code.
Is it possible to view a data element’s option name in the pivot table instead of the option code?
Is there another way to do this? Maybe this is in the new Pivot Table (New Pivot Table App )? The last resort here will be an ETL process that loads this in, but that is not ideal.