2 Replies Latest reply on Jul 14, 2018 9:08 AM by Adam Aliz

    How to dynamically show the last 12 months in view?

    Adam Aliz

      Hi tableaurs,

       

      If i input the data such as month and value , it should only update for the last 12 months and show only the last 12 month records in view. how to do this?

       

      Example :

         

      OrderdateApplicationNumber
      Jan-18AAA10
      Feb-18BBB15
      Mar-18CCC7
      Apr-18DDD3
      May-18EEE21
      Jun-18FFF4
      Jul-18GGG5
      Aug-18H1
      Sep-18I2
      Oct-18K3
      Nov-18N33
      Dec-18L9

      If i insert , orderdate as "Jan-19", Applcation as "ZZZ". Number as "100" . It should automatically update in tableau and show only the last 12 month records, from Feb 18 to Jan 19 . how to get this?