Ad Hoc Report stacked columns series by time

[mariana_]

I need to create Ad Hoc Report by several Time Series. On X axis I want time YYMM (I created this field in my DB table from year and month, since I could not display the composite group year&month). Then I have a numerical field Value by Series that I want to display as stacked columns. So the data looks like this (simplified with 3 time points and 2 series):

Time  Series Value

201004   A    5

201004   B   15

201005   A   10

201005  B   12

201006  A   4

201006  B   11

The chart should display the 201004 to 201006 on the axes X and the stacked columns consist of the values for A and B. I also want % columns that add to 100% as you can do in Excel.

How do I do this within JasperServer?

Post Edited by mariana_ at 08/02/2010 21:50