3 Replies Latest reply on Nov 9, 2018 9:25 AM by Don Wise

    Lookup Amount from a Fixed Period

    Bryan Adkison

      Hello, I'm new to Tableau and would like to create a calculated field which returns the 'Amount' based on a fixed Fiscal Period. I converted the Fiscal Period to a String to make it simpler but unsure how to lookup that value.

       

      My logic is: 'IF [StringFiscalPeriod] = 201901 THEN [Amount] END  -> which would return only 6,188.

      Demo.PNG

      In this case I only want to lookup a value based. I can't use a filter as my Viz is already using it in other columns.

       

      Any advice on how this can be calculated is appreciated!