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
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