Difference between Highest Dates

Hi,

I'm working on Notifications Cube, and have to create one simple report. Report should display number of Days between two (latest) notification types for a Functional Location.

E.g. Notifications Cube contains below contents:

Functional Location Notification # Notification Type Created Date

ABC-123 111 Z1 1-Jan-10

ABC-123 112 Z1 3-Jan-10

ABC-123 115 Z1 20-Jan-10

ABC-123 130 Z1 15-Mar-10

ABC-123 155 Y2 30-Mar-10

XYZ-333 215 Z1 23-Feb-10

XYZ-333 230 Z1 28-Feb-10

XYZ-333 255 Y2 2-Mar-10

And I've to create Report with below output:

Functional Location Number of Days (between Y2 and Z1)

ABC-123 15

XYZ-333 2

How can I achieve this?

Regards,

Vikrant.