8 Replies Latest reply on Feb 25, 2016 9:07 AM by Justus Niemzok

    Please help, I need to show a filter which my users can use to select 1 month, the data table will then update to show difference in sales vs. prior month

    Lucy Jones

      Hi all,

       

      I am hoping you can help me. I need to show the month quick filter which my users can use to select 1 month, the data table will then update to show difference in sales vs. prior month. I can do it but currently my users have to select 2 months and the comparison will be calculated based on these 2 months. I want the user to be able to select 1 month only and then it will automatically calculate the difference vs. the prior month. For example if they were to select December it would automatically show Dec vs. Nov results and if they were to select June, it would automatically select June vs. May results. Is this possible?

       

      Thank you very much.

      Lucy