| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| Print Pivot Table headers on pages with Pivot Table | Excel Worksheet Functions | |||
| Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
| Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
| Help required with setting up a pivot table with the source on sheet1 to have the pivot table created on sheet called "report" | Excel Programming | |||
Threaded Mode
