Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table Page fields
Hi
I need some help with the page fields settings on the pivot chart. When you drag an item into the page fields then automatically in the drop down menu for that item we find ALL option which I do not require. Is there a way to remove that? Ex: Say my item is GROUP and has A, B and C. When I drag this into the page fields I find A B C and also ALL in the drop down menu for the item Group. Can any one suggest me how to get rid of that ALL option? Any help would be greatly appreciated. Thanks Ajit |
#2
|
|||
|
|||
Hi
I don't think you can hide the All option. But, take a look at Debra Dalgleish's site and you may find a way around your problem. http://www.contextures.com/xlPivot03.html Regards Roger Govier Ajit wrote: Hi I need some help with the page fields settings on the pivot chart. When you drag an item into the page fields then automatically in the drop down menu for that item we find ALL option which I do not require. Is there a way to remove that? Ex: Say my item is GROUP and has A, B and C. When I drag this into the page fields I find A B C and also ALL in the drop down menu for the item Group. Can any one suggest me how to get rid of that ALL option? Any help would be greatly appreciated. Thanks Ajit |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Cycling Through Page Fields Automatically | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
Multiple selection in the page area of a pivot table | Excel Discussion (Misc queries) | |||
pivot table question, sum fields? | Excel Worksheet Functions |