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