Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Feild List
I Hope some one can help with this. I have a Pivot Table that has year
to day payrol data, i have a summery report based on that Pivot Table. Is it possible to place a combo box on my summary report that will "Filter" the information without changing the Pivot Table. for example data feilds: Pay perids 1 - 7 Select period6 Manger Jane Doe Cost Center 1033 I can get to the cost centers in a combo box (Using Pivot!$A$10:$A$35 in the listfillRange) but the Manager are on the page level so when i use Pivot!$B2 I get only the option "ALL" and not Man 1, Man 2, Man 3 etc. Please Help.. Im going crazy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Feild List
You could make a copy of the pivot table, and store it on another
worksheet, which could be hidden. In the new pivot table, put all the fields you need to filter on in the row or column area, so they're visible. Then, in the summary report, you can use GetPivotData formulas to pull the data, based on the selections in the combo boxes. There are GetPivotData examples in Excel's Help, and he http://www.contextures.com/xlPivot06.html Ifatooki wrote: I Hope some one can help with this. I have a Pivot Table that has year to day payrol data, i have a summery report based on that Pivot Table. Is it possible to place a combo box on my summary report that will "Filter" the information without changing the Pivot Table. for example data feilds: Pay perids 1 - 7 Select period6 Manger Jane Doe Cost Center 1033 I can get to the cost centers in a combo box (Using Pivot!$A$10:$A$35 in the listfillRange) but the Manager are on the page level so when i use Pivot!$B2 I get only the option "ALL" and not Man 1, Man 2, Man 3 etc. Please Help.. Im going crazy -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table List | Excel Discussion (Misc queries) | |||
pivot table list for web | Excel Discussion (Misc queries) | |||
Excel should automaticaly update a feild when printing ex:Version | Excel Worksheet Functions | |||
Pivot Table Sort & Top List | Excel Discussion (Misc queries) | |||
Need help with Drop-Down list and Pivot Table | Excel Worksheet Functions |