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
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.