1 Reply Latest reply on Oct 22, 2018 7:35 AM by Ombir Rathee

    Drop down date filter after filtering with table calculation

    marko.tikkanen

      Hello,

       

      I'm trying to make a simple KPI report with sales of month X and percent difference to previous month. To make the percent difference calculation I use table calculation filter LOOKUP(MIN([Order Date]),0) so the value of previous month doesn't get filtered out before the calculation takes place.

       

      The problem is that I need to be able to select any month and with table calculation filter I seem to be able to only use the relative date filter. For the end user it would be much better to have a drop down menu to select the desired month. Is it possible to do this?

       

      Thank you in advance