C cyrilz New Member Apr 13, 2010 #1 Hello, I'm using a pivot table with a filtered row list (suppressed empty labels). My question is how do I automatically add new label to my table when the originating data changes. Thanks for your help. Cyirl
Hello, I'm using a pivot table with a filtered row list (suppressed empty labels). My question is how do I automatically add new label to my table when the originating data changes. Thanks for your help. Cyirl
C cyrilz New Member Apr 13, 2010 #2 I've found what I was looking for. When you deselect some values in a row, you can add automatically new values with the following method: 1. Right click in the header of the field (either in the table or in the right-hand list in 2007 2. Go to Field Parameter : in 2007 you have a check box named "Filter / Add new items in the manual filter". 3. Check it and there you are. HTH Cyril
I've found what I was looking for. When you deselect some values in a row, you can add automatically new values with the following method: 1. Right click in the header of the field (either in the table or in the right-hand list in 2007 2. Go to Field Parameter : in 2007 you have a check box named "Filter / Add new items in the manual filter". 3. Check it and there you are. HTH Cyril
