Hi,
Do you have an idea how I can filter automatically a pivot table by getting data from a cell and thus using this data to filter the pivottable?
For example, on cell A1 I have EU, and I want to use a region filter for a pivot table. How can the pivot automatically detect that A1 is EU and therefore automatically filter the pivottable to EU values only?
Thanks in advance!
vasco
Bookmarks