It might not be so obvious how to create a stacked bar chart with DBxtra.
So; here is a simple example.
Let’s take a look of the underlying query.
We have built a simple Sum query for customer sales by customer and month.
We added a top 5 to the query.
Let’s open the DBxtra Visual Report Designer.
Click on "Advanced Chart Wizard".
Select "Bar Stacked" as chart type.
Select the "Data" tab and choose "Auto-created Series".
On "Series Properties" select Series "Data.Customer".
On "Argument Properties" select Argument "Data.YY-MMMM".
On Value "Value Properties" select Value 1 "Data Invoice Total".
Adjust all other Chart formatting to your likings.
Save the Report.
Let’s take a look at the finished Report.
See also: Chart