2 Replies Latest reply on Aug 20, 2018 3:17 AM by Devin Smith

    Ammend Headers to show the from date and to date

    Devin Smith

      Good Morning All,

       

      Had a request from a department to show the date specific headers as the from and to date and not just the year.

       

      Currently, I am splitting the columns by years - displaying 2016, 2017 and 2018 and i want them to show the months that are selected based on parameters, for example 1 May 2016 - 31 July 2016

       

      My headers display as such:

       

       

      I need these to be replaced by my month parameters and years:

       

       

      I want to share a workbook however the data is sensitive to all parties concerned.

       

      I have tried the following:

       

      created a calculated field called DATE PARAMETER - it contains the following:

       

      STR(MIN([Business Date]))+ ' - ' +STR(MAX([Business Date]))

       

      however, the problem is if i drag it onto either the rows or columns it gives the start date specific to the table column not to the filter:

       

       

      I basically want a placeholder above the column to state the start and end date of the filter itself