2 Replies Latest reply: Sep 25, 2017 12:17 PM by youssef belloum RSS

    Set analysis or Calculation Condition

    Erica Trotter

      Hi, I am trying to create a table with the following dimensions:


      Week: Current Week and the same week last year

      Month: Current Month and the same month last year

      Current Year and Prior Year


      Should I use set analysis in each of the measures, or a calculation condition and how would I go about writing it?

      My time variable is

      [Week of Hours Worked]

      [Month of Hours Worked]

      [Year of Hours Worked]