There's the running-total function, but it occurs to me that it is possible that your question is actually more complex than that and, consequently, you might want to describe in more detail what problem you are encountering.

When you work with the relative time measures you need to understand that they contain a time element in addition to the fact itself.  Using them with your time dimension what can appear to be weird results if you don't keep in mind that the report is going to show you values only for those dates in the scope of the relative time period as set by the as of date setting.

Here's a fragment of a list report for a CA server where the as of date is April 15,2012.

There's the running-total function, but it occurs to me that it is possible that your question is actually more complex than that and, consequently, you might want to describe in more detail what problem you are encountering.

When you work with the relative time measures you need to understand that they contain a time element in addition to the fact itself.  Using them with your time dimension what can appear to be weird results if you don't keep in mind that the report is going to show you values only for those dates in the scope of the relative time period as set by the as of date setting.

Here's a fragment of a list report for a CA server where the as of date is April 15,2012.

https://community.ibm.com/community/user/businessanalytics/blogs/ian-henderson1/2019/10/17/cognos-analytics-modelling-expression-editor?CommunityKey=6b10df83-0b3c-4f92-8b1f-1fd80d0e7e58&tab=recentcommunityblogsdashboard

Here is something which I hope helps you work with the expression editor to achieve your aims.

There's the running-total function, but it occurs to me that it is possible that your question is actually more complex than that and, consequently, you might want to describe in more detail what problem you are encountering.

When you work with the relative time measures you need to understand that they contain a time element in addition to the fact itself.  Using them with your time dimension what can appear to be weird results if you don't keep in mind that the report is going to show you values only for those dates in the scope of the relative time period as set by the as of date setting.

Here's a fragment of a list report for a CA server where the as of date is April 15,2012.

https://community.ibm.com/community/user/businessanalytics/blogs/ian-henderson1/2019/10/17/cognos-analytics-modelling-expression-editor?CommunityKey=6b10df83-0b3c-4f92-8b1f-1fd80d0e7e58&tab=recentcommunityblogsdashboard

Here is something which I hope helps you work with the expression editor to achieve your aims.

There's the running-total function, but it occurs to me that it is possible that your question is actually more complex than that and, consequently, you might want to describe in more detail what problem you are encountering.

When you work with the relative time measures you need to understand that they contain a time element in addition to the fact itself.  Using them with your time dimension what can appear to be weird results if you don't keep in mind that the report is going to show you values only for those dates in the scope of the relative time period as set by the as of date setting.

Here's a fragment of a list report for a CA server where the as of date is April 15,2012.