Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table
How do I assign a value to a pivot table field based on a cell value?
I have a plant name and I want it to be selected based on the plant name I have on the A1 cell... can I do it? Plant (All) Customer Site (Multiple Items) Sum of Reject Qty Month Universal Code Jan Feb Grand Total 0000000000 96 434 530 0000002700 17 117 134 0100000000 378 1319 1697 0100000014 3 23 26 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table
This will tell you pretty much everything you want to know about pivot tables:
http://www.contextures.com/xlPivot01.html Look at the topic list towards the bottom of the page!! Take a look at this too: http://www.contextures.com/excelfiles.html#Pivot Finally, double-click anywhere in the Pivot Table to create a new sheet witl all matching values. HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Alberto Ast" wrote: How do I assign a value to a pivot table field based on a cell value? I have a plant name and I want it to be selected based on the plant name I have on the A1 cell... can I do it? Plant (All) Customer Site (Multiple Items) Sum of Reject Qty Month Universal Code Jan Feb Grand Total 0000000000 96 434 530 0000002700 17 117 134 0100000000 378 1319 1697 0100000014 3 23 26 |
Reply |
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 |