9 Replies Latest reply on Mar 8, 2016 8:49 AM by Sash L.

    Getting the previous value within State and Category

    Sash L.

      Hi,

      Attached some sample data and a simple table. I want the table's tooltip to show the previous period's value of the same category, and if possible, the previous period (so in the tooltip should read e.g.: "Previous period (xxxx)'s value: 5.2").

      My issue is to get a calculated field that gives me this info. I could not manage to combine a FIXED with Previous_value (I assume this is what I have to do)? Still a bit lost with these basic tableau functions it seems.

       

       

      Any help is appreciated!

       

       

      Edit: better sample data