Thanks for the call-out, Santhosh, but I'm swamped today. I hope someone else can take a look.
I'm looking at this today.
What are you looking to sort? Are you saying for the pageviews piechart you want the wedges to sort by SUM(Pageviews)? And for the Visits piechart you want the wedges to sort by SUM(visits)? Etc.
If so, I would break that into three separate sheets and then you can set separate sorts for each pie chart. As it is now, you can't specify varying sort criteria by measure when you have are using MeasureNames/MeasureValues technique.
So make separate sheets and just place them adjacent to each other on your dashboard. You can make it look the same as a single sheet.
As for top-5, what are you looking to do here?
Thanks Joe for taking time on this.
Yes, we can show it in separate Sheets but we have many other worksheets to display in the same dashboard and it will become more complex. I think, we will stick with dropdown menu option.
Are you all set on this, or do you still need help here?