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

[#2]

try using

if(GetCurrentField(<CyclicGroupName>)='Year',Month(Max(Date)))

[harleen_singh]

Nagaraj,

              it did not worked. Well i am not looking for Maximum date, I am looking for Value at Maximum date.

thanks

Lavi

[#4]

Hi Lavi, You can directly use the Expression in your cyclic Group

YearMonth --> YearMonth

Year --> Aggr(Max(Month) , Year)

[harleen_singh]

Dathu,

             it returns maximum month in cyclic group that is ok.

but i want to return also the "Value" at maximum month

value in my case is "countofincidents"

thanks

Lavi

[#6]

If the Dimension have max Month value, the expression returns the coountofincidents for that month.

CountofIncidents is a expression or ?