I have opportunity summary report in my application which is currently pulling Opportunities whose start date is greater than last quarter's first date. So in my class where condition of my query is-
WHERE Flight_Start_Date1__c >= :lastQuarter.StartDate
But now I want that there should only be one record of the Opp for each Fiscal Qarter, Fiscal Year, and Fiscal Period, with the report displaying the most recently pulled record.Could anyone please suggest what can be WHERE condition to achieve this. Thanks in advance.