Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 28th 07, 04:34 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 5
Default pivot table to contains more than 1 field groups

Hi there,
i have 3 work sheets with these data fields: RO, ROC, CO
RO is customers order where the new orders for the model will be placed.
the data field is "model","po number", "ord qty", "del date"

ROC is when customer request to make changes to the RO they already made
the data field is "model","po number", "change qty", "change date"

CO is issued when the customer finally confirms their order
the data field is "model","po number", "del qty", "del date"

As you all may seen, the model name and po number must matched up in these 3
fields.
I want to use pivot table function to make a table that sort according to
model name, po number and shows the RO qty, del date, then shows ROC qty and
dat, and the CO qty and date.
but for the pivot table to work, i have to join the info's of the RO, ROC,
CO work sheet together according to the model name and po number. Although
using vlookup function to match and then copy the qty and date info is
relatively straight forward,

IS THERE ANYWAY I CAN create multiple pivot table field lists (eg. RO, ROC,
CO field list) and throw the info into a single pivot table, so that Excel
will automatically group according to model name and po number for me?

i hope i post my question clear and understandable. really appreciate the
feedback from you all.
thank you all very much.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to make a field created a part of the Pivot Table Field List? drhell Excel Discussion (Misc queries) 0 January 29th 07 11:13 PM
Pivot Table groups & cumulative totals laureleaw Excel Discussion (Misc queries) 0 April 26th 06 08:53 PM
Pivot Table Groups Chris Excel Worksheet Functions 2 February 24th 06 06:42 AM
Pivot Table Date Groups MarkN Excel Discussion (Misc queries) 2 February 16th 06 12:39 AM
pivot table and groups tysop Excel Worksheet Functions 1 January 24th 06 06:33 PM


All times are GMT +1. The time now is 03:35 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017