LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 4th 05, 06:43 PM
Brian Lofquist
Posts: n/a
Default Pivot Tables, can I use an external list to select data items?

I have created a pivot table from a data set. Rows contain Purchase Order
Numbers, data is Open amounts. There are approx 300 Purchase Order numbers
in the Pivot Report. I have an external list of the Purchase Orders I want
to include, approx 175. Is there a way to use the external list to select
the purchase order for the Pivot Report?

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
The pivot tables 101 article says to use the "Create List" comman. cgnoland03 New Users to Excel 2 January 14th 05 11:39 PM
Pivot and changing External data source Peter Excel Discussion (Misc queries) 3 January 13th 05 04:59 PM
Pivot Tables referring to external data query Excel GuRu Excel Discussion (Misc queries) 4 December 29th 04 06:29 PM
Pivot Tables multiple data fields Excel GuRu Excel Worksheet Functions 2 December 16th 04 12:06 AM
Pivot Table - Group by Month - Show Items with no data Dan Reynolds Excel Discussion (Misc queries) 0 November 28th 04 01:01 AM

All times are GMT +1. The time now is 12:40 PM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017