1 2 Previous Next 18 Replies Latest reply on Oct 4, 2016 11:34 AM by David Li

    How to calculate weekdays dynamically and sum of those days of current week as well as last week

    Anandh V


      I want to compare the total sales of Sunday,Monday,Tuesday,Wednesday of last week with Sunday,Monday,Tuesday,Wednesday of current week.

      i want to display the last week first 4 days total sum value and as well as current week 4 days total sum value. the values should change based on the date changes.


      Ex: if am in thursday of current week means i need have a total of all the completed days wednesday,tuesday,monday,sunday of current week and relevant days in the last week also.


      whenever the date changes accordingly i need to display the total sales dynamically in Tableau.


      Let me know any questions.



      Please help me to achieve this.@


      Thanks & Regards,


        1 2 Previous Next