Problem with aggr over dimension

[#1]

Hello, I am building an application to show some training courses statistics. Courses have expiration dates and when they are expired they need to be taken again.

For example person 7096 took the course 842 second time and it is compliant at the moment.

%PersonnelNumber	Course Number	Course Date	Expiry Date	Status
00007096	00000842	29/03/2012	28/03/2014	Non Compliant/Expired
00007096	00000842	10/04/2014	09/04/2016	Compliant

Now I want to show status for the employees of their courses but obviously I do not want to show ‘Non Compliant’ if the expired course was retaken.

I try to create chart and table using aggregation function. I try to aggregate data for given person and course only with maximum date

count(Aggr(max([Course Date]),[%PersonnelNumber],[Course Number]))

But it is not working. When I try to prepare a table or a chart with Status dimension I get a correct count of 1 but for ‘Non Compliant’

What I do wrong? I am attaching example application with one employee and charts to show the problem.

Any help would be appreciated,

Regards,

Mat

[#2]

Sunny, I think it works now. Was much more difficult than I thought but good that it finally works.

Thanks

[sunny_talwar]

Hahahaha ya, I have been in your place many times. But I am glad we finally found the solution.

Best,

Sunny