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

    value at maximum month in cyclic group

    Harleen Singh


               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





      I am trying this formula but it is not working



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