Pivot Table Columns

  • Thread starter Thread starter Art
  • Start date Start date
A

Art

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?
 
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.
 
Thanks for your reply. However this is not quite what I need. Below is an
example of the finished arrangement:

User ReportID ReportName Count
Hicks 12
22 MoneyMarket 10
73 Loans 2
Jones 18
15 Futures 18
Patel 21
73 Loans 4
88 Tbills 17

The count will be a count of ReportID. The data is set up so that each
distinct type of report must have its own unique ReportID. However, it is
possible that two or more report versions (IDs) have the same ReportName. So
I do not want to count or analyze ReportName, but I do need it appear in the
finished table alongside the ReportID column.
 
Back
Top