Set analysis - last run date for user statistics

[#1]

Hi everyone,

I'm creating a dashboard which shows the user statistics for our suite of BI reports.  I want to decommission reports which haven't been used this year and show a list of the reports in a straight table like this:-

I have written the following set analysis:  =Max({<FinancialYear-={'2014-2015'}>}ReportDate)

This is showing the last time it was run before this year and so heavy duty (recently run) reports are coming up with 31/03/2014 as the last run date when I want to show the last time it was run not including any which may have been run in 2014/15.  I hope that makes sense?!

Is what I want to show acheivable with set analysis?  Where am I going wrong?

Thanks for any help you can give

Natalie xXx

[Gysbert_Wassenaar]

Maybe like this:

=Max({<ReportName=E({<FinancialYear={'2014-2015'}>}ReportName)>} ReportDate)

If not, then please post a document that demonstrates the problem.

[Anonymous]

Hi,

try:

=Max({<FinancialYear={'<2014'}>}ReportDate)

[#4]

Morning

Thank you for your responses but neither of those have worked and I can't attach a document as it's on our server and doesn't have an URL.