View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Negative numbers in pivot table

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.

"Alonso" wrote in message
...
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??