set maximum date of each month in set analysis

[vengadeshpalani]

Hi

i want to show a count of DJobID in MonthYear wise in straight table

but it won't consider all date it shout be maximum Date

so i use

count({<Date = {'=Aggr(Max(Date),MonthYear)'}>}DISTINCT  DJobID)

for Jan 2013 it will be 6 but it shows only 5 What did i wrong?

[sunny_talwar · Accepted solution]

May be try this

FirstSortedValue(Aggr(Count(DISTINCT DJobID), Date, MonthYear), -Aggr(Date, Date, MonthYear))