3 Replies Latest reply on Oct 5, 2015 11:36 AM by Vijaya Pediredla

    Concatenating two variables then formatting one

    . Jawon

      Say I have two variables City and State. Is there a way to get the following result...

       

      Have "City, State" show up as values (not headers) within a crosstab. I know I could just concatenate via a calculated field and then put it in the Text shelf. But I'd also like to format the State variable to have different colors.

       

      So for example, I would see "Chicago, IL" as a value within a crosstab and all "IL" would be red.