Thanks Petri, for your suggestion. I actually have values coming in from various systems and the values are alphanumeric, For eg, I have some values like CHQ114, A679, 9769, CBH. These values are connected to various categories and depending on the category value the measure value is to be reported. Issue is that the value column is alphanumeric and therefore being treated as category.
... View more