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

Showing total for only the last month

Started by vcatarello, 08 Sep 2020 09:10:39 AM

Previous topic - Next topic

vcatarello

Hello,

I have months Jan, Feb, Mar of 2020 but only want to show the total sales for the last month only. Is there a way to have this done?

Thanks

bus_pass_man

Yes.   It really depends on your data and your data sources but it can range from easy peasy to a bit less so.

If you are using a module you can set up relative time measures.  One of the out of the box measures is last month.

If you data source supports the concept of relative time (a dynamic cube or mdc for example) then that's built in too or available via a dimensional function.

In general a filter of some sort could be of use.