View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
trip_to_tokyo[_2_] trip_to_tokyo[_2_] is offline
external usenet poster
 
Posts: 70
Default Pivot Table Columns

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