Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try using
if(GetCurrentField(<CyclicGroupName>)='Year',Month(Max(Date)))
Nagaraj,
it did not worked. Well i am not looking for Maximum date, I am looking for Value at Maximum date.
thanks
Lavi
Hi Lavi, You can directly use the Expression in your cyclic Group
YearMonth --> YearMonth
Year --> Aggr(Max(Month) , Year)
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
If the Dimension have max Month value, the expression returns the coountofincidents for that month.
CountofIncidents is a expression or ?