Hi,
I have a dataset that contains a lot of different attributes, ie sector, country, rating, market cap, and there is a column for each attribute type. The last column is return (or Profit/Loss) and I want to make a chart for each attribute using the same dataset as the source for all charts. The reason for this is that I do no want to call the same stored procedure 4 times to request the same data. Is there any way to tell the chart to group by a certain column and sum the results of the return column? All of these charts would be vertical bar charts.
Thanks,
Boyd