8 Replies Latest reply: Jan 28, 2010 1:01 PM by adrianrichards RSS

    Set analysis using only

    adrianrichards

       

       

      =

      sum({<MonthendDate = {"<=$(=Only(MonthendDate))"}, MonthendDate = {">=$(=addmonths(=Only(MonthendDate),-12))"}>} XXNET)

      I am having difficulty with a set analysis, I am trying to have a chart show the monthenddate selected and the 12 months going backwards. My expression is not working , wondered if anyone can see what is wrong.

       

      Thank you

       

      Adrian