COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: sravantig on 09 Mar 2012 11:10:29 AM

Title: Sum up the districts in a line chart
Post by: sravantig on 09 Mar 2012 11:10:29 AM
Attachment shows different districts with turnover rate as measure for years 2010,2011(all dimensions and measures are from a cube)
I need to sum up all the districts as a number instead of showing them individually.

Please help me... I've posted similar question many times but none replied.
I'm newbie need your help please. :(
Title: Re: Sum up the districts in a line chart
Post by: blom0344 on 09 Mar 2012 01:36:17 PM
Attaching meaningless very small images does not help   ;)

It is also unclear what you need to achieve . Do you mean that you need to calculate the turnover rate OVER all districts? A rate is normally not an additive measure, so it is quite a mystery what you want..

Can you shed some light on this?
Title: Re: Sum up the districts in a line chart
Post by: sravantig on 09 Mar 2012 03:09:41 PM
Yes I need the overall turnover rate for a region(which has different districts as members). basically I need a line chart for year 2010 to 2011 for the whole region... but when I'm pulling the region to my series... the chart shows the turnover for each district individually.