View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Marilyn Marilyn is offline
external usenet poster
 
Posts: 211
Default Filtering credits in a Pivot Table

Hello I created several pivot tables using the same data source. In one of
the pivot tables I need to show credits only. Here is the layout of the
table on the "ROW" section I have invoice year (2004 2005 2006 2007 ) on
the "DATA" I have total sales. Here is the problem all I want to show is the
credits (e.g. -3,256 ) on this particular table without having to change the
source thanks