Hi
I'd like to filter by the values I have in my pivot table and I've attached the screenshot to help me explain.
I have 'sums of clicks', 'count of CTR', sum of revenue' as separate columns but I want them as one filtered column like I have with Row Labels. I want to have the drop down menu so I can select to show either 'sums of clicks', 'count of CTR' or 'sum of revenue' in column B6 so that the graph then displays just one line instead of all of them at once.
I still want all the data there, I just want to be able to select to see it individually then quickly select another. I'm making a marketing dashboard to monitor analytics so I want to be able to view as many variables in as neater way as possible.
On the highlighted section on the graph, I want one drop down menu where it says 'sum of clicks' smilar to the line above it.
I'd appreciate any help you can give me.
Many thanks
Bookmarks