2 Replies Latest reply on Apr 3, 2018 5:56 PM by Zhouyi Zhang

    This time last year without Hide

    Kenneth Tsang

      Hi Tableau,

      I am trying to show a value of a measure 12 months ago. I've been able to get some success using this formula:

       

      lookup((SUM([Sales])),-11)

       

      But it involves actually having the full 12 months on the screen. I would like to be able to report on a single headline figure for my dashboard. In this example i would like to report on 0.7768 as my headline figure. How do i do this without hiding the rest of the fields?

      Note: Hiding is not ideal as by the time the next month comes along, you will need to manually hide it. I know there must be some way of using the date calculations but not sure how to proceed.

       

      Thanks in Advance,

       

      Kennethtableau_12_months.PNG