View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Old Keith Old Keith is offline
external usenet poster
 
Posts: 31
Default Excel 2007 Pivot tables

I have a report that has a column of numbers which contain a mixture of
positive and negative numbers. I'd like to use the pivot table to sometimes
exclude the postive numbers and sometimes to exclude the negative numbers,
but I can't figure out how to do that. I can sort and extract, but it would
be great if the pivot table could handle it.
All help is, as usual, greatly appreciated.