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

Could you possibly upload a file with sample data showing expected results?