COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: qvixote on 05 Apr 2017 12:27:48 PM

Title: Create ogive chart
Post by: qvixote on 05 Apr 2017 12:27:48 PM
Hello!

Making a report in report studio, over a transformer powercube, there's a calculated measure I need to include in a linear chart, having weeks on the x axis. But I need the chart to be ogive like, it means, de value over weeks needs to be acumulated, so, if in the first week the measure value is 5, second week 3, third week 6, then the chart has to show 5 for the first week, 8 for the second week (first + second) and 14 for the third week (first + second + third) and so on.

Is there a way to make a "cumulative" calculated measure?

Thanks in advance.