software

I have created a Pivot Table that looks exactly as I want it. I have a group
of people listed with their departments and a list of planned hours. My
pivot table gives totals of the planned hours by department. This works
perfectly. My problem now is, I need to add actual hours to both the detail
and summary tables (and probably calculate a variance). I have not been able
to do this, and every time I try to create another table, it gives me a count
of people by department. Please help. Thanks.

Have you added an Actual Hours field to the source data, and included
that field in both pivot tables?

Larry S. wrote:
gt; I have created a Pivot Table that looks exactly as I want it. I have a group
gt; of people listed with their departments and a list of planned hours. My
gt; pivot table gives totals of the planned hours by department. This works
gt; perfectly. My problem now is, I need to add actual hours to both the detail
gt; and summary tables (and probably calculate a variance). I have not been able
gt; to do this, and every time I try to create another table, it gives me a count
gt; of people by department. Please help. Thanks.--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.htmlIn the detail spreadsheet, I have Name, Department, Maximum Utilization (Per
Week), and Actual Utilization (Per Week). Right now I have departments going
down in the Pivot Table. The heading of the Pivot Table says Sum of Maximum
Utilization (Per Week) The second column says Total, this is the sum of each
departments planned utilization and is correct. What I want to do is add a
third column for actual and a fourth for variance %. The closest I have
gotten is creating a second line for each department with the actual
utilization. Please help!! Thanks.

quot;Debra Dalgleishquot; wrote:

gt; Have you added an Actual Hours field to the source data, and included
gt; that field in both pivot tables?
gt;
gt; Larry S. wrote:
gt; gt; I have created a Pivot Table that looks exactly as I want it. I have a group
gt; gt; of people listed with their departments and a list of planned hours. My
gt; gt; pivot table gives totals of the planned hours by department. This works
gt; gt; perfectly. My problem now is, I need to add actual hours to both the detail
gt; gt; and summary tables (and probably calculate a variance). I have not been able
gt; gt; to do this, and every time I try to create another table, it gives me a count
gt; gt; of people by department. Please help. Thanks.
gt;
gt;
gt; --
gt; Debra Dalgleish
gt; Excel FAQ, Tips amp; Book List
gt; www.contextures.com/tiptech.html
gt;
gt;

If you drag the Actual Utilization field to the data area, it should add
a column with Sum of Actual. Then, you can add a calculated field with
the variance formula.

To add a calculated field, select a cell in the pivot table, and choose
PivotTablegt;Formulasgt;Calculated Field.

Larry S. wrote:
gt; In the detail spreadsheet, I have Name, Department, Maximum Utilization (Per
gt; Week), and Actual Utilization (Per Week). Right now I have departments going
gt; down in the Pivot Table. The heading of the Pivot Table says Sum of Maximum
gt; Utilization (Per Week) The second column says Total, this is the sum of each
gt; departments planned utilization and is correct. What I want to do is add a
gt; third column for actual and a fourth for variance %. The closest I have
gt; gotten is creating a second line for each department with the actual
gt; utilization. Please help!! Thanks.
gt;
gt; quot;Debra Dalgleishquot; wrote:
gt;
gt;
gt;gt;Have you added an Actual Hours field to the source data, and included
gt;gt;that field in both pivot tables?
gt;gt;
gt;gt;Larry S. wrote:
gt;gt;
gt;gt;gt;I have created a Pivot Table that looks exactly as I want it. I have a group
gt;gt;gt;of people listed with their departments and a list of planned hours. My
gt;gt;gt;pivot table gives totals of the planned hours by department. This works
gt;gt;gt;perfectly. My problem now is, I need to add actual hours to both the detail
gt;gt;gt;and summary tables (and probably calculate a variance). I have not been able
gt;gt;gt;to do this, and every time I try to create another table, it gives me a count
gt;gt;gt;of people by department. Please help. Thanks.
gt;gt;
gt;gt;
gt;gt;--
gt;gt;Debra Dalgleish
gt;gt;Excel FAQ, Tips amp; Book List
gt;gt;www.contextures.com/tiptech.html
gt;gt;
gt;gt;
gt;--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.htmlI am still not doing it correctly. It is adding a row for each department
and not adding an additional column.

quot;Larry S.quot; wrote:

gt; I have created a Pivot Table that looks exactly as I want it. I have a group
gt; of people listed with their departments and a list of planned hours. My
gt; pivot table gives totals of the planned hours by department. This works
gt; perfectly. My problem now is, I need to add actual hours to both the detail
gt; and summary tables (and probably calculate a variance). I have not been able
gt; to do this, and every time I try to create another table, it gives me a count
gt; of people by department. Please help. Thanks.