| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting Information from A Pivot Table
I Have a Pivot Table that I would like to
Give a count of pieces by: Having the date(s) in the Date Column equal a certain date, Example 1-Jan-06,If that conditon is met, then Having the Mode of Transport Column equal " MC" if that condition is met, then In the Piece Count Column, adding the number of pieces that meet the above criteria and then giving me a total in a cell. Thanks, -- Jim Patterson |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extracting Information from A Pivot Table
You can use the GetPivotData function to pull specific data from the
pivot table. There's information in Excel's Help, and he http://www.contextures.com/xlPivot06.html Jim Patterson wrote: I Have a Pivot Table that I would like to Give a count of pieces by: Having the date(s) in the Date Column equal a certain date, Example 1-Jan-06,If that conditon is met, then Having the Mode of Transport Column equal " MC" if that condition is met, then In the Piece Count Column, adding the number of pieces that meet the above criteria and then giving me a total in a cell. Thanks, -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extracting Information from A Pivot Table
Thanks, I will take a look at this link.
-- Jim Patterson "Debra Dalgleish" wrote: You can use the GetPivotData function to pull specific data from the pivot table. There's information in Excel's Help, and he http://www.contextures.com/xlPivot06.html Jim Patterson wrote: I Have a Pivot Table that I would like to Give a count of pieces by: Having the date(s) in the Date Column equal a certain date, Example 1-Jan-06,If that conditon is met, then Having the Mode of Transport Column equal " MC" if that condition is met, then In the Piece Count Column, adding the number of pieces that meet the above criteria and then giving me a total in a cell. Thanks, -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2k Pivot Table refresh scenario | Excel Discussion (Misc queries) | |||
| OLAP Pivot table - How to show items with no data ? | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| How to get information from a Pivot TAble without retyping? | Excel Discussion (Misc queries) | |||
| Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Hybrid Mode
