![]() |
#1
|
|||
|
|||
![]()
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 |
#2
|
|||
|
|||
![]()
Could you possibly upload a file with sample data showing expected results?
|
![]() |
|
![]() |
||||
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 |
![]() |
lilvillaf | Excel | 2 | 06-12-2014 05:39 PM |
![]() |
udea | Excel | 1 | 04-25-2011 02:34 AM |
![]() |
youngsc | Excel | 1 | 03-29-2010 06:49 AM |