3 Replies Latest reply on Dec 8, 2017 6:48 AM by Roberto Nieto

    Previous week of filtered data

    Roberto Nieto

      Hello everybody,

       

      I have come across with the following issue and I am unable to find a correct approach, I need to create a dashboard that filters SALES and AVERAGE SALES by week, an important part of this is to be able to compare to previous week, something like this:

       

       

       

       

       

       

      So essentially is the below, but rather than being  based on a table calculation needs to be a calculated field.

       

       

      Any ideas how to approach this?

       

      Thanks

       

      Roberto