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