Dear Forum,
I'm working on a dashboard where I have a nice pivot table and pivot chart. The data is geographical, I have States, DMAs, Demographic groups and Population in it. I filtered out the pivot table and now it show's the Top 10 DMAs and Top 5 Demo Groups by Population.
I would like to create a 2 buttons under my chart. 1 of them would show the "next 10" DMAs the other would show the "previous 10" DMAs but I can't figure out how to make the pivot table filter "next 10" or "previous 10". There are approximately 200 DMAs in the US.
Can anybody suggest a solution?
Bookmarks