7 Replies Latest reply on Dec 18, 2013 7:03 AM by Eric Munisteri

    Value of the latest week in a month

    Thomas de Ruiter

      Hi all,

       

      I'm fairly new to Tableau.

      Hopefully you can help me out with this, probably simple, question.

       

      For one of my reports I am importing data on a weekly basis, but I want to report on a monthly basis.

      Unfortunately, one of the values is a cumulative number. Meaning: the value of week 44 = the value of week 43 + the results in week 44. When I use this value in a report with MONTH(Date) in the column, I get the SUM of all the weeks in that month.

       

      Is there any way to report the value of the latest week date a month, without summing all the valuea within the month?

       

      Many thanks in advance for your help,

      Thomas