Thanks Jerry for your reply. I tried this option. However it refreshes the complete dashboard and we don't want this.

Thanks Christian for the replies. I applied sorting in views and applied filter on Rcount<=10 in criteria tab. Still its not taking top 10 rows based on sorting order. How the filter should be applied to get top n distinct rows after sorting?

I tried creating two different views by using view selector. However, I'm unable to get top 10 records based on different columns(i.e Revenue, Units) through single criteria. I used RCOUNT in criteria tab and it always generates count based on the first sorted column which is Revenue in my case.

Thanks Christian for your reply. My requirement is to show top 10 data for Revenue in Desc order on one graph and show top 10 data for Units in Desc order on another graph. I can switch between graphs by toggling from one value to another(i.e Revenue/Units). Is there any way to achieve this?

I've already tried "view selector" and was having issues with sorting columns based on selected view. In my snapshot, I've applied sorting on "Total Price for sort" and "Balance for Sort" columns. When I toggle to "Balance", it still shows the graph in desc order wrt to Total Price only. I'm not sure how sorting on columns…

Thanks for the prompt reply. Much appreciated. I feel i'm closer to fixing this just last few hurdles... When I put data values (Col1,Col2) in the "Vary colors by" drop area it shows the sum of Col1 and Col2 values across all records. Refer to the attached screenshot: Ideally on hover for bar 2012, Col1 should be 121 and…

Thank you for your reply. I could see the two new columns on hover after adding them to "Bar" drop area. But the 2 new values are also visible in Horizontal axis.I want to display only Year value in X axis... Also Is it possible to change the order in hover like Year Amount Col2 Col1 Currently amount is always shown last.

Thank you for your reply..But I think i was not clear with my initial post and this is what i'm looking for... I have a yearly bar graph on a dashboard. Now I want to drill down a yearly graph to Monthly graph. On clicking a particular year, it should be replaced with monthly *bar* graph and monthly view should show all…