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?

Ex:
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.

|
|---2300
|
|--------------------1500
|______________________________
----brandA--------brandB


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


|
|
|----500
|--------------------300
|___________________________
----brandA--------brandB


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!