It seems that the stacking is based on analysing a trigger field, say Status, and using the same value field out of every record, thus creating a stacked bar.
I have another scenario: My invoices table has the fields Invoice Amount, Payments made, Outstanding. I would like to stack these fields into the same bar. As it stands I can't find a way to do it. I would have expected to be able to define more than one Y-Axis field to achieve this.
Date Created 1/10/2012 12:22:22 PM
Date Updated 4/2/2013 4:00:32 PM
Status New Idea
Ton Jense 4/2/2013 4:00:32 PM
This would be easy if it would be possible to create a stacked bar chart from a summary or a crosstable view in stead of individual records.