If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Last run of each month

Started by JBCLARK20, 02 Nov 2017 02:11:42 PM

Previous topic - Next topic

JBCLARK20

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?