View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Art Art is offline
external usenet poster
 
Posts: 587
Default Pivot Table Columns

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