| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| The pivot tables 101 article says to use the "Create List" comman. | New Users to Excel | |||
| Pivot and changing External data source | Excel Discussion (Misc queries) | |||
| Pivot Tables referring to external data query | Excel Discussion (Misc queries) | |||
| Pivot Tables multiple data fields | Excel Worksheet Functions | |||
| Pivot Table - Group by Month - Show Items with no data | Excel Discussion (Misc queries) | |||
Threaded Mode
