View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
legs legs is offline
external usenet poster
 
Posts: 4
Default pivot table, grand total no negatives

My data in my pivot table holds negative numbers, therefore my Grand Total
minuses these negatives, ie 6, -2, 4 grand total = 8.

I need the Grand Total to only add anything over 0, so the above equation
would equal 10.

Is there anyway in the pivot table I can do this?

Thanks