COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: joecog on 21 Apr 2011 09:25:36 PM

Title: Create Pie Chart with Multiple Years
Post by: joecog on 21 Apr 2011 09:25:36 PM
Hi ,

I had a crosstab report as below :

Year          Region      Sales Amt
2008           2               100
                   3               200   
                   4               150 
                   5                50
                   6               300

2009           2               500
                   3               20   
                   4               750 
                   5               950
                   6               800

2010           2               580
                   3               600   
                   4               450 
                   5               250
                   6               300


How do I create 3 pie chart for 3 years (2008,2009,2010) with Region as the pie slice.


Title: Re: Create Pie Chart with Multiple Years
Post by: PRIT AMRIT on 21 Apr 2011 10:15:43 PM
Put the [Year] in Categories(pies), [Region] in Series(pie slices) and [Sales Amt] in Default Measure.

It will create pie chart for each Years.

Hope should help?

Thanks
Prit
Title: Re: Create Pie Chart with Multiple Years
Post by: joecog on 21 Apr 2011 10:34:12 PM
Hi Prit,

It's working...
Many thanks.


Joe