2 Replies Latest reply on Jun 21, 2016 10:14 AM by Sharad Adhikari

    Calculate last year data without aggregating or using windows max

    Sharad Adhikari

      Hi,

       

      I have attached a tableau workbook where I have tried to calculate the data from last year from same period as this year's data.

       

      I have three columns YearWeek, First day of week and EUR.

       

      I would like to sum up the 9.3.2015 data as it is more than first week of 2015 and less than last week of 2016.

       

      How could I calculate the last years data without need of aggregating EUR or using windows max? I have managed to sum up the amount but it is working only when I put YearWeek in the view.

       

      BR

      Sharad