View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alonso[_2_] Alonso[_2_] is offline
external usenet poster
 
Posts: 58
Default Negative numbers in pivot table

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??