Skip to Content
0
Former Member
Mar 28, 2009 at 12:04 AM

How to only display latest date record on query output?

337 Views

My Price custom cube contains multiple rows per material, each of which has an Effective Date characteristic. How do I display only the latest record in my query? I have sorted Effective Date descending, but only want one row displayed per material.

Thanks,

Geoff