8 Replies Latest reply on Sep 20, 2017 10:24 AM by Charan Loya

    Tableau Filter on Max date

    Charan Loya

      Hello,

       

      I have a trending chart and i am trying to create a filter that filters data for the values based on the Max(Date) but would still show the trend for the filtered dimensions. I have trouble creating the right logic. Could one of you please take a look and help me with it?

       

      Please find the attached example with superstore data set. As a preview in the below image i have created a filter to show sum(sales) >5000, 1000 - 5000 and <1000, i am basically trying to keep only the values that are < 1000 for the max(Date). So my below image should basically only show Art, Envelopes, Fasteners and Labels for all the months in the trend. Hope my question is clear.

       

      Looking for inputs.

       

       

      Thanks,

      CL