4 Replies Latest reply: Oct 13, 2016 10:26 AM by Deepanshu Chamoli RSS

    Static Date

    Deepanshu Chamoli

      Hello All

       

      Please help me in the below query.

       

      I have the data from 2013 to 2016... In the visualization I need to show the max date.

       

      I am using the formula as MAX(date)..

       

      The issue is that if I select any month on the sheet it will change and shows that particular month max date.

       

      I want that it will always show the max date of the data.. No matter what the filter we apply.

       

      Please suggest.

       

      Thanks!!