Pivot Table problem.

[cyrilz]

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

 

[cyrilz]

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

 

[keymaster]

That is pretty cool... thanks for sharing it with us