2 Replies Latest reply: Nov 2, 2010 8:22 PM by Luis Laura RSS

    Set Analysis - PrevMonth with unselected fields

    pedro.dongo

      I have to fields for selecting months: Month (1,2,...), MonthName (Jan,Feb,..). Now I wan to select Previous Month in the chart

       

      sum({$<Month={$(=Only(Month)-1)}>}Amount)

      But my selections are in MonthName field not in Month. How can I refer to Previous Month if I have to select month in MonthName not in Month field? I mean when I select February, I want to show January too?