View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Cam Cam is offline
external usenet poster
 
Posts: 165
Default Pivot table help

Hi,

I have a pivot table in the following layout below. The problem is if I have
more than one order# on the same date, it will only display one order#
(either max or min). How can I arrange or format the pivot to display two
order# on the same date if they fall into the same date in the column? Thanks

Row: Part#, Opr and Qty
Column: Date
Data: Order#

Part# Opr Qty 3/20 3/21 3/24 3/25
02-230 50 12 31265 31562
02-245 100 6 30563 31861
02-361 20 12 30653

Say, order# 35560 with same part#, Opr and Qty fall into date 3/21 also, I
would like to show both 31861 and 35560 on the same cell. How can I achieve
this?

Part# Opr Qty 3/20 3/21 3/24 3/25
02-230 50 12 31265 31562
02-245 100 6 30563 31861
35560
02-361 20 12 30653