8 Replies Latest reply on Sep 7, 2018 4:02 AM by amar savale

    Bypassing Date filter for rolling months

    Thomas Kont

      Hallo everyone,

       

      i need some support from you. I am trying to create a Report which Shows me the value of the Chosen reporting date and the last day of last month based on the Chosen reporting date.

       

      For example i choose the reporting date to be 31.08.2018 in my quickfilter. Then there should be 2 values shown. The value for 31.08.2018 and the value for 31.07.2018. I am not able to do these. I know that i can FIXED the value using LOD. But i am actually trying to fix the Dates instead. But it will not work with LOD.

       

      I have attached the workbook. I hope someone can help me on this.

       

       

      Thank you

       

      regards

      Thomas