forget abt the above expression.
My requirements are :
1.Dateid's are there for each and every Fiscal date.So i want to pick up the max(dateid) of that particular month for that entire years.
2.I want to display the sum of values of only maximum Date id of that particular month(in straight table).
can you please help me out in writing set expression for this.