Stacked Barchart

[Leandro]

[EDITED]
Hello,
Im trying to create a stacked barchart.

I have a query:

select date, region, sum(sales) as sumsales from company_sales group by date, region

I need to create a serie in stacked bar for each region. But it is only creating one serie (sumsales).

Atached is a image with a example of the chart that i need...

i'm sending my xaction too, please guys, could you see whats wrong?? Any sugestion is welcome!

really thanks!

[Leandro]

I found a issue in jira about my problem. But no solutions at all...

http://jira.pentaho.org:8080/browse/...s:all-tabpanel


Any Idea??/ Pleaseee

[Leandro]

Hey Guys,
the solution for that problem is to use the crosstab component:

http://wiki.pentaho.com/display/Serv...ltset+Crosstab

Thanks kappa!!