• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Report Filters in Pivot Table

rongda

New Member
Hi,
I have two report filters in my pivot table in Excel 2007, Region and Town. How to let Town filter only list the town names that are in the region I selected in Region filter? Please help.
Thanks.
 
Hi rongda,

Welcome to the forum..

Yes.. in case of VBA, using Dependent Data Validation techniques, and after seelction, setting the .CurrentPage is a option, however..

If you have 2010 + version of excel, you can use "Slicer", where, you can set the setting parameter ..

19-11-2014 05-37-03.jpg

"Hide Item with No Data"..

It will hide the Dependent Slicer's item's which are not applicable..
 
Hi Debraj:
Thank you for the quick response. But it took mw awhile to make it work. I really appreciate your time. This is a nice place to learn.
Thanks again.
Rongda
 
Back
Top