3 Replies Latest reply: Nov 21, 2011 8:19 AM by Steve Baldwin RSS

    Summarizing sales for day-364

      I want to summarize the sales for the day which is 364 days before the day in the dimension.

       

       

      Therefore I built the following expression:

       

      SUM({$<DAY={$(=Only(DAY)-364)}>}SALES)

       

      But the outcome is always 0.

      What did I do wrong?

      Thanks for your help.