Adding Rows of Data (And Calculations) to a Pivot Table

[rjbinney]

I have created a pivot table that lists employees ("Resources") down the rows, and each column is a calculation of how much project work they've been assigned to in a given week. (The underlying table lists resources in individual projects, the pivot is to "roll up" the totals).

What I'd like to do is:

Under each row (i.e., under each Resource), demonstrate how much REMAINING time in a work week they have. Essentially, it would be "=40-[cell above]".

So what I have is:

RESOURCE | WEEK ONE | WEEK TWO | WEEK THREE |
rjbinney | 12.5 | 27.1 | 18.5 | 10.5
alincoln | 10.0 | 15.0 | 10.0 | 5.0

What I'd like is:

RESOURCE | WEEK ONE | WEEK TWO | WEEK THREE |
rjbinney | 12.5 | 27.1 | 18.5 | 10.5

| 27.5 | 12.9 | 22.5 | 29.5

alincoln | 10.0 | 15.0 | 10.0 | 5.0

| 30.0 | 25.0 | 30.0 | 35.0

Any advice would be appreciated.

rjb

[:) Sixthsense :)]

It will be helpful to suggest something if you attach a sample workbook for better understanding

[VKS]

Hello rjbinney,
Welcome to the forum. Have added a 2 calculated items for you. Please check the attached file.
Best Regards/VKS