Multiple Data Sources - 1 pivot table

G

Gringarlow

I have 2 tables of data, they have a field NAME in common. One table is a
summary of data showing %'s of certain occurances, the other is a listing of
work items. I tried to build a pivot table using multiple ranges, but am
unable to achieve what I need. I need to show the NAME field with the summary
%'s and then have the ability to select the individual name and get the
listing of work items for that name.I think I'm in way over my head at this
point.
 

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

Consolidation Table from Different Excel Tabs with Different Format 1
VBA Filtered Pivot Table Showing "Multiple Values Selected"; Only One Value Selected 0
Pivot Table Management 4
Change SourceName on Pivot Table 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Pivot tables using multiple tables 5
How I can set dynamic pivot table ONLY when I have enough data point 1
VBA Pivot Table: Determining item from one field based on anotherfield item 0

Top