2 Replies Latest reply on Jul 27, 2017 10:36 AM by Galen Busch

    Add text to crosstab

    Alex Martino

      Hello. I have a crosstab with one measure. How can I add "text" to the crosstab. For example if it says 126 I would like to add "days" to the end.

        • 1. Re: Add text to crosstab
          Ben Neville

          You should have a measure field on Text. All you need to do is click on Text, the ellipsis next to the popup (...) and then type whatever you like in the box. You likely have SUM([SomeMeasureHere) or something similar - just type "days" after that.

          • 2. Re: Add text to crosstab
            Galen Busch

            Hi Alex,

             

            I might recommend approaching this as a string.


            Create a new calculated field - let's call it "Measure with Days"

             

             

            STR(SUM([Days])) + ' Days'

             

            Where SUM() is your aggregation, and [Days] is the field returning the number of days.

             

            Give this a shot, put it on your viz, and you should be set!