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.