Hello Art. I think that what you want is possible. I have put up a proposed
solution for you at:-
www.pierrefondes.com
I think that this gives you what you want.
It is prepared in EXCEL 2007.
"Art" wrote:
I have the following data in a table:
User
ReportID
ReportName
I have created a pivot table that groups by user and then ReportID, and
shows a count of the different reports run by each user. I would like to add
another column containing ReportName. The ReportName always corresponds to
the ReportID, so I do not need any additional summaries. Is this possible?
--
Art