10 Replies Latest reply on Jun 29, 2018 11:37 AM by Gerardo Varela

    Simple Calculation? Max String Possible?

    Jonathan Hodge

      Howdy all!

       

      Concept of a Max String sounds goofy just saying it but I have a year column in my data for Fiscal Years.

      Right now I see 2017, 2018, 2019. The user has requested these years be columns that appear as "FY 2017" "FY 2018" "FY 2019 YTD".

      For the "FY 2019 YTD" to be dynamic I need Tableau to know that 2019 is the highest/max/last value to attach a "YTD" to the end.

       

      I've been playing with the calculations a bit but attempting to mix aggregates with strings and integers that need to output strings has been a mess lol.

       

      Does anybody have any advice or ideas by chance?

       

      Thanks!