View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
ExcelPower
 
Posts: n/a
Default Eliminate Duplicates in Pivot Table


If u put PO Number in "row" & also Item Number in Row, While date/month
in "column" & Product/ Item(Count) in "data". u should get the total of
Item count per PO. It shows total of Item Per Po Number. But Can not
ignore on the ground of uniqueness. But no TWo or More Entries will be
shown of Item Per PO . I think this should solve your problem


--
ExcelPower
------------------------------------------------------------------------
ExcelPower's Profile: http://www.excelforum.com/member.php...o&userid=30964
View this thread: http://www.excelforum.com/showthread...hreadid=507770