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

You are going to have to make Order Number one of the ROW items. It isn't
exactly what you want, but it's the best you're going to be able to do.
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Cam" wrote:

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