9 Replies Latest reply: Mar 3, 2011 12:10 PM by Chinmay Herwadkar RSS

    SET Analysis -By MonthID/MontNumber (Does not work when MonthName is selected)

      Hi Everyone,

      Requirement - Chart Showing Sales for 6 Months - Selected Month -2, Selected Month, Selected Month +2.

      The above requirement has been achieved using the MonthID/MonthNum as a numeric value is required to set the Month Range. (QVW Attached)

       

      Now when I Add a Listbox with MonthNum it works fine.

      When I Add a Listbox with MonthName it fails.

       

      The Month names are in the format : JAN FY2011 so a direct addmonths can not be applied or if it can be please let me know how.

       

      Regards,

      Chinmay