Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table page fields add values previously deslected
I have pivot tables that I have selected only certain data in a page
field by dragging it to the detail, selecting only what I want, then dragging it back to the page section. The problem is that when new data shows up in the file, it automatically adds that data to the field. This can cause erroneous information to be reported. Is there any way to stop it from doing this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table page fields add values previously deslected
you can use the page field. Drag field codes to the Page Field. Leave "all" selected 1- right click on top field bar. 2 - Select "Field Settings": at the botton you have the option to HIDE items. 3- Just select the ones that you DONT want. -- Portuga ------------------------------------------------------------------------ Portuga's Profile: http://www.excelforum.com/member.php...fo&userid=6385 View this thread: http://www.excelforum.com/showthread...hreadid=547078 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to eliminate xero values from pivot table and list top 10 only | Excel Worksheet Functions | |||
flattening aggregated fields in pivot table | Excel Discussion (Misc queries) | |||
Count unique values - Pivot Table | Charts and Charting in Excel | |||
Manipulating Pivot Table Data Fields | Charts and Charting in Excel | |||
pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) |