4 Replies Latest reply on Mar 21, 2016 7:32 AM by Alexander Gress

    Sales Data of the last month and still chose a different month with dynamic data updates

    Alexander Gress

      Hello,

      I have sales data of the last 18months. The sales data is updating every night. So a new day is always added.

       

      1) The graph should show the sales data per day of the current month. This is not a problem. But I would also give the user the ability to chose a different month of the last 18 months.

       

      2) It is getting tricky when a new month starts. So the graph should show the new current month per day, but the user should also be able to chose a different month.

       

      I have a workbook which gives me the first solution. But I have to upload again when the new month starts since the parameters is stuck on the month when it has been uploaded.

       

      Thanks

      Alex