0 Replies Latest reply: Feb 22, 2012 12:06 PM by Mark Orchard RSS

    Offset Week in Expression

      Hi there

       

      Can anyone help me with this one, basically due to the way we calculate the years week numbers this year has a week 1 but last year did not.  The desire is to she week one TY but against Week 2 from last year numbers.

       

      I cannot change the week on the source data and as a result have been working with set analysis.

       

      On one instance where the user had to select a week i used the below :-

       

       

      =sum({$Year = {$(=max(Year)-1)}, Week = {$(=getfieldselections(Week)+1)}>} sales)

       

       

      However I am now trying to do the same offset but on a pivot chart where i have weeks in columns.

       

      I tried to do a similar set analysis but with no joy .....

       

      Avg({$<Year = {$(=max(Year)-1)}, Week = {$(=Week+1)} >} sales)