Issue Can't Sum Up in Report Studio Cognos BI 10.1

[kenrisen]

Dear Cognos Experts,

Kindly help to solve issue in Cognos BI report studio.
Here is the description of the problem :
Our client have report in BI Cognos 10.1 to display trend in this year and last year.
Every year our client perform audit process, the amount after audit process will be placed in the database (SAP BW) with period called special period (period 13, 14, 15, 16).
There's requirement that the report needs to sum up Special Period amount into December amount.
In this report the user is able to choose the fiscal year period.
The case is if the user choose Dec 2012 then the report will display amount from January 2012 (001.2012) to Special Period 2012 (016.2012), but the amount of Special Period will be summed up into Dec 2012 amount. Else if the user choose period other than Dec for example November, then the report will display amount from January 2012 to November 2012.
The question is : Can cognos BI sum the value from 2 months into 1 month ?
For instance, December 2012 amount is 10,000 and special period 13 amount is 5,000. Therefore the report has to display value 15,000 for December 2012 and we will filter out month 13 to 16.

Please check the attached file to be more specific.

FYI : we use SAP BW as our data source for BI reports and sum up can't be done in SAP BW.

Thank you.
Regards,
Giok Ty

[mrcool]

Create a dataitem for months with a case statement like

case period

when 1 then jan
when 2 then Feb
..
..
When 11 Then Nov
Else
Dec
End

Hope this helps.

[kenrisen]

Dear Mrcool,

The case is not that simple. The requirement is to sum up the value of January into February. Below is the example.
We have data item :
January value = 1000
February value = 500

The expected result is :
February = 1500
January value will not be shown in the chart (I want to filter out the January value)

Thank you.
Regards,
Giok Ty

[kenrisen]

Dear Cognos Experts,

Any update regarding the issue of mine?

Thank you.
regards,
Giok Ty

[kenrisen]

Dear All Cognos Experts,

Is there any update regarding this issue ?

Thank you.
regards,
Giok Ty

[kenrisen]

Dear All,

Any update about the issue ?
Has anyone facing the same issue ?

Thank you.
regards,
Giok Ty