Hi guys,

Is it possible for a chart to use the summary result of a GroupingStore instead of just the last entry in the store?

here's my data:

brand | item | amount
brandA itemA1 1000
brandA itemA2 500
brandB itemB1 2000
brandB itemA2 300

In my chart, i want to show the total amount per brand.


however, it only shows the last entry on the store (or just one item)


Is there any way in which the chart would read the data based on the result of the grouping store's summary?

Or any workaround like populating a new store based on the summary results of the original groupingstore, and using the new populated store as the chart's store?

Any help would be great... Thanks!