0 Replies Latest reply: Nov 13, 2012 5:05 AM by An Fe RSS

    Sum Last Year with specific Date

      Hi,

      I have a table like this:

      - TableTransaction (DateTrans, Total)

      - TableWeekCY (Year, Week, DateTransCY)

      - TableWeekLY (Year, Week, DateTransLY)

       

      Example, I have a data like this:

      YearWeekDateTransCYDateTransLY
      20124009/04/2012 - 09/10/201209/06/2011 - 09/12/2011

       

      I want to display Sum(Total) in 2 column, that is Total for CY and LY based on Current Selection (Year and Week). How do the Expression if I made it on the pivot table?

       

      The Output is like this:

      TotalCYTotalLY
      999,999999,999

       

       

      I norm the table into like this:

      - TableWeekCY (Year & '-' & Week as CodeWeekCY, DateTransCY as DateTrans)

      - TableWeekLY (Year & '-' & Week as CodeWeekLY, DateTransLY as DateTrans)

       

      Thank you.