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!