4 Replies Latest reply on Jul 24, 2012 11:10 AM by John Woolley

    Limit Year Filter to 4 recent years

    John Woolley

      I have a table with entry dates ranging over 15 years, but I want to limit the graph view to the most recent four years.

       

      The standard on-screen filter shows all 15 years. I wrote a simple calculated field to isolate the last four years, but all the others fall into a Null bucket on screen which I don't want.

      There must be a simple solution that I'm missing.

       

      Thanks,

       

      John