Crosstab to Combination chart

[patel45]

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