Negative numbers in pivot table

[Alonso]

I have a table with sales
some of them are negative cause those were returned by the customers

I'm trying to get a pivot table with the total
but to show somewhere the positives
then the negatives
and at the end the grand total

can this be done??

 

[Fred Smith]

If this was me, I would create separate columns in the data table for
positive sales and negative sales. Then summing them separately in the pivot
table is easy.

Regards,
Fred.