Last Modified Date: 10 Oct 2016
- Tableau Desktop 10.0.1
ResolutionUse the LOOKUP() table calculation. If the current mark is less than the target value, or the current mark is >= target value and the previous mark is not, this calculation returns True:
NOT([!Meet or Exceed Target?]) OR [!Meet or Exceed Target?] AND NOT(LOOKUP([!Meet or Exceed Target?], -1))Drag this calculated field to the Filters shelf.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials