Hi, new to the forum here looking for some pivot experts!
I have two pivot tables as seen in the attachment. My goal is to be able to filter "Second Level" and automatically have the second pivot (Rightside) filter the associated "User Groups"
So the end result... if i filtered "Reports (USA)" on the first table, the second table will automatically only show data for the groups Approvers, USA Visitors, and Editors - USA.
Any tips or suggestions are greatly appreciated!
Bookmarks