"list" summary function in Excel or SQL

B

Bob

I have an excel pivot chart pulling from a SQL Server view. The chart
is formatted as a bar chart, with various page, category, series
values. The bar chart is great for showing the number of items that
match the criteria. However, I'd like to see the actual details
inside the chart. Specifically, I'm showing software problem reports
(SPRs) on the chart. The data item I'm graphing is "count of SPRid."
I can pick from various summary operators such as count, sum, average,
etc. I'd like to have a "list" operator that would comma-separate the
underlying values. Is this built in to Excel or SQL somewhere, or is
there a way to plug in my own?

Thanks,
Bob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

charting multiple identical x values overlapping 0
Presenting all months in a year in a Pivot Table/Chart when allmonths are not included in source dat 0
Excel Bar Charts Issue - How Dynamic can charts be? 0
Requesting help to generate progress reports in Excel ... 0
switching the axes, categories to values and vice versa 0
Problem with stacked column chart 5
Hiding zero values on a chart in Excel 2007 2
Multi Axis Pivot Chart 12

Top