1 Reply Latest reply on Jul 18, 2018 2:37 PM by Patrick A Van Der Hyde

    Parameter to filter dates in only one measure?

    simone magagnini

      Hello everyone!

       

      Please help!!!! :-)

       

      I am struggling with a view (more on calculations) using a report which is generated in millions of cells (so cant do manual work) .... but I have below columns I need to use (just a summary):

          

      Forecast For All Months / FYActualsMonthMonth Report Generated
      435,970,766436,179,412Jan-1830/06/2018
      728,575,144658,242,166Feb-1830/06/2018
      712,061,197676,758,014Mar-1830/06/2018
      665,857,499647,103,165Apr-1830/06/2018
      653,249,900640,106,863May-1830/06/2018
      898,767,660924,913,651Jun-1830/06/2018
      436,191,078436,179,412Jan-1831/05/2018
      658,141,453658,242,166Feb-1831/05/2018
      677,195,580676,758,014Mar-1831/05/2018
      647,133,181647,103,165Apr-1831/05/2018
      634,875,382640,106,863May-1831/05/2018
      841,317,492 Jun-1831/05/2018

       

       

       

      Our forecast changes every month (dont ask!) and when the forecast is for the current month it is overwritten by the actuals (so in June/18 my actuals and forecast are same) and that is my major problem.. I need to compare actuals against all previous months but can only select them using the Month report was generated...so confusing!

       

      so probably I need a paramenter to only filter forecast by the months selected while Actuals remain the same as FY (or YTD depending on what month we are) ... I am so brainless as I have been trying to work on smth for hours and nothing :-(

       

      it would be fantastic if anyone could help me (Ps. I have not attached any workbook here coz data is sensitive)

       

      THANKS HEAPS HEAPS HEAPS in advance!