Hi Excel Forum, this is my first post.
I'm in deep need of help. I work as a student helper, and my job is to create reports for each of the departments of the school I work for. These reports include showing the changes in Headcounts from quarter to quarter and the distribution of the different professions for each department.
I have created a Pivot Table for each quarter I have data for. Now I need to find a way to "combine" these Pivots in such a way, that I will be able to show the changes that happen from quarter to quarter in each department. I want the row labels to include each sub-department (there can be more sub-departments in quarter 2 than quarter 1 and this has to update automatically) and I want the column labels to state each quarter with the corresponding data down through the columns.
I am currently working in Excel 2010 as this is the version used by my boss and coworkers.
I have been fiddling around with this for so long and I am yet to find a solution to my problem.
Every attempt of helping me will be much appreciated!
- Max
I'm in deep need of help. I work as a student helper, and my job is to create reports for each of the departments of the school I work for. These reports include showing the changes in Headcounts from quarter to quarter and the distribution of the different professions for each department.
I have created a Pivot Table for each quarter I have data for. Now I need to find a way to "combine" these Pivots in such a way, that I will be able to show the changes that happen from quarter to quarter in each department. I want the row labels to include each sub-department (there can be more sub-departments in quarter 2 than quarter 1 and this has to update automatically) and I want the column labels to state each quarter with the corresponding data down through the columns.
I am currently working in Excel 2010 as this is the version used by my boss and coworkers.
I have been fiddling around with this for so long and I am yet to find a solution to my problem.
Every attempt of helping me will be much appreciated!
- Max