1 Reply Latest reply on Aug 27, 2018 4:25 AM by Andrew Watson

    Showing weekly and MTD numbers

    Varun Gupta

      Hi,

       

      I'm stuck in my dashboard view. Any help would be well appreciated.

       

      I have a table which shows weekly sales numbers segregated into each date

      19th Aug
      20th Aug21st Aug22nd Aug23rd Aug24th Aug25th Aug

       

      I have a separate table which shows MTD number. So if a user selects 19th - 25th week, MTD number would reflect 1st Aug to 25th Aug data.

      Since the user has an option to select any week, say 12th - 18th Aug or 5th to 11th Aug, I want my MTD number to change accordingly.

       

      Any thoughts?