Hi,
I have a pivot table that shows two levels of column data (team and their corresponding product). I want to have a 'Top x' filter at the team level, however, it doesn't work when I have the Product column there as the 'parent' column. I've attached a sample workbook that also has a hard-coded example of the desired output of how I want the pivot to look.
thank you
Bookmarks