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

# value at maximum month in cyclic group

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

• ###### Re: value at maximum month in cyclic group

try using

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

• ###### Re: value at maximum month in cyclic group

Nagaraj,

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

thanks

Lavi

• ###### Re: value at maximum month in cyclic group

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

YearMonth --> YearMonth

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

• ###### Re: value at maximum month in cyclic group

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

• ###### Re: value at maximum month in cyclic group

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

CountofIncidents is a expression or ?