5 Replies Latest reply: Feb 17, 2014 9:35 AM by Srikanth P RSS

    value at maximum month in cyclic group

    Harleen Singh

      Hii,

               I have created a cyclic group between Yearmonth and a Year.

       

      So, when user see data at Month level it should show monthly data that's fine.

       

      but when choose Year(in cyclic group). I want to show Value for the maximum Month for that Year.

       

      so if data is like this for MonthYear

       

      Jan  Feb Mar Apr

      20    30  20    50

       

      so when user choose Year(in cyclic Group)

       

      It should show

       

      Year

      50

       

      I am trying this formula but it is not working

       

       

      =Sum({< Month={'$(=Month(Max(Date)))'}>} countofincidents)

       

       

      thanks

      lavi