COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: patel45 on 09 Apr 2012 04:23:16 PM

Title: Crosstab to Combination chart
Post by: patel45 on 09 Apr 2012 04:23:16 PM
Hello Everybody

I will explain my issue by giving example and using Go Sales Package in which I have crosstab table and Column values are in years i.e. 2005, 2006, 2007, 2009, 2011. Rows values  are ProdLine1 , ProdLine2, ProdLine3 and measures is Revenues.

The Values of Years and ProdLine we get it from prompt page as per user selection. My Requirement is to Generate five different combination chart for each year using crosstab rows and columns values. Chart will be plotted as:  X-axis =  Prodline, Y axis = Revenue.

Please can anyone explain me in detail How should i achieve above task.


Thanks,
Patel45