Pivot Table Custom Calculations

C

CassieM

I have a pivot table with the "columns" set up as Budget - Actual - Variance
for each month of the year. The rows are the expenses account, such as
supplies, maintenance, etc.

I want to be able to add the total of the "Actual" spent through September
plus the "Budget" for October through December, basically to get a projected
total by expense for the year.

How can I do this? Thanks for your help!
 
D

Debra Dalgleish

You could add a column to the source data, and calculate which amount
should be used. Then add that field to the pivot table. For example,
with dates in column A, Budget in C, and Actual in D:

=IF(A2>=TODAY(),C2,D2)
 

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

Similar Threads

Pivot table 0
Pivot Table Hide Selected Field 2007 0
Pivot Table 2007 display field only in Grand Total 0
Microsoft Project 2016 Monthly Cost Report/ Table Creation Help 0
Pivot table and variance calculation 1
Problem with Calculated item in Pivot Table 0
Problem with Calculated item in Pivot Table 1
Pivot Table Set Up 2

Top