Create calculated field in pivot table that will sum all values greater than zero/exclude negative values

[BryanRk]

I'm trying to create a calculated field in a pivot table that will sum all the values greater than zero. It's an easy thing to do outside of the pivot table, however, the people using this spreadsheet are not all excel savvy, and everything else is linked to the pivot table. I don't know if it's possible. I was hoping i could just do ="fieldname" >0 but that only returns a 1 or a 0. Within this field are about 1000 numbers, some are negative, some are positive, i am trying to have the pivot table return the sum of the positive ones in one column, and the sum of all the negative ones in a different column. I can easily do a sumifs function outside of the pivot table, but I would much rather have it included in the pivot table. Thanks

 

[RoryA]

Unless you have a Power Pivot (an add-in for 2010), you will need to add two columns to the source data to do those calculations, then you can just sum them in the pivot.

 

[BryanRk]

I'm actually in excel 2013. Would i have it then?

 

[RoryA]

I think it was a free add-on for 2013