9 Replies Latest reply: Oct 14, 2011 2:37 AM by rohit gupta RSS

    Sales for Month of previous year (Set Analysis)

      I'm sure i'm just missing something simple for this one....

       

      all my dimensions are real dimensions and not calculated.  There are no selections made in the doc.

       

      My pivot dimensions are:

      • product
      • year "SaleYear"
      • month "SaleMonth"

       

      the expressions i want are:

      • sales for the month from the dimension --> easy "Sum(Sales)"
      • sales for the month of the previous year for that dimension <---- this is just giving me $0 "Sum({1<sale_date={"=InMonth(sale_date,SaleMonth,-12)"}>} Sales)"

       

      any ideas?