|
|
#1
10-15-2016, 03:03 AM
|
|||
|
|||
Consolidation of multiple sheets in Pivot
Hi,
I have 4 people reporting to me sending production report of their teams every week... If I want to use consolidation option in pivot it consolidates as per the first column... However, i may want to do an analysis of employee wise for each team, team wise, quarter, avg production etc... Im using only Excell 2003... Below is my output required... What are my options if consolidation of multiple sheets is not my best choice... Team Team 1 Process FY FW Emp id Emp Name EMP ID EMP Name GC EC GC-Length EC-Length Target Variance 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Multiple found values from five sheets, multiple returned values in sheet six? | irisha | Excel Programming | 26 | 09-30-2016 01:20 AM |
| copy second row from multiple sheets | Brian Reilly | Excel Programming | 1 | 03-30-2015 01:21 PM |
 Fetching more than one result with VLookup on multiple sheets
|
lilvillaf | Excel | 2 | 06-12-2014 05:39 PM |
|
form a database from multiple sheets
|
udea | Excel | 1 | 04-25-2011 02:34 AM |
|
Excel Consolidation Problem
|
youngsc | Excel | 1 | 03-29-2010 06:49 AM |
Windows XP 
Office 2003
Threaded Mode