Pivot Table exclude negative values from sum

G

Guest

Using Excel 2007:
I am using a pivot table to sum staff by department. Some departments have
positions shown as a negative (indicates they belong to a different
department/budget). When I include the FTE column in my pivot table to
summarize staffing by department, it adds the negatives making the total
incorrect.
How can I get the table to sum only if values are greater than zero?
 
G

Guest

You could add an extra field into your source data flagging negative values.
Assuming your FTE's are in colmun B you could use a formula like =B2>0 to
return simple true false flags...
 
G

Guest

Perfect. Thank you for the idea. That worked.

Jim Thomlinson said:
You could add an extra field into your source data flagging negative values.
Assuming your FTE's are in colmun B you could use a formula like =B2>0 to
return simple true false flags...
 

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