I have a data source with snapshots of data. One snap shot for each report_date.
I want to summarize the data from the last report date in each month over 18 months.
So if the last report date in June was Jun 28 and the last report date in July was Jul 29 then those are the snapshots I want to evaluate.
Is there a way to do this with queries in Report studio?