Hi,
I have created a Pivot table using multiple tabs (see the attached example). I would like to use the Top 3 Filter function, showing the top 3 "Items" by "Clicks", and not by the "Sum of Value" that use to calculate both columns, and showing the Top 3 considering the sum of "Clicks" and "Impressions".
When I create the Pivot table using the same data, but across only one tab, under Values I have both, "Clicks" and "Impressions", and also when filtering by Top 3 I'm able to choose which one, "Items" by "Clicks", instead of "Items" by "Impressions".
Thanks a lot!
Bookmarks