3 Replies Latest reply on Mar 13, 2017 8:33 AM by Sue Grist

    Get % change between 2 specific measure values

    Sue Grist

      I'd like to have a calculated field that tells the % change between the Year = 2000, and Year = 2012, for each "Attribute" Dimension.

       

      I know I need to use LODs, but can't seem to get it quite right.

       

      In the attached Tableau v10.1 packaged workbook, in Sheet 4 you can see my failed attempt at this.

       

      Where I'm trying to go with this is to include that value in the dashboard as either a tooltip entry or maybe as an annotation.

       

      Can anyone help?