PivotTable question

D

Dylan

I have a PivotTable with a list of projects and the monthly cost for each
project. At the bottom of the table is several rows of non-project costs.

For example:
Project ID Jan Feb March etc. SubTotals
Project1 £50 £60
Project2 £60 £70
Project3 £70 £80
Cost 01 £20 £30 £40
Cost 02 £30 £40 £20
Cost 03 £40 £20 £20

With projects starting and ending in different periods, I want spread the
sum of the non-project cost across the projects that are active for each
month.

So with my example, the total non-project cost for Jan is £90 and active
projects are Project 1 and 3. Project 1 Value would increase to £95 and
Project 3 value to £115.

I have a little experience in using PivotTables and imagine it could be
done, can you please advise, or help me to set it up?

Kind regards
Dylan Dawson
 
Joined
Apr 29, 2008
Messages
66
Reaction score
0
I'm afraid I don't think you can do this all in a pivot table. You can set up formulas in pivot tables but these can only be at row level and can't refer to totals.
You could either make use of the pivot table as your starting point with some additional formulas alongside it or go back to the source data and use formulas containing SUMIFs.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top