The requirement is to display say Sales where the difference between Order Date and Ship Date is < 90 days. Both Order Date and Ship Date are dimensions with Sales Fact table.
How do I aggregate the Sales measure only for those records where the date diff is < 90 days?
This is against DMR using MDX.