How to dynamically change chart dimension to other in dashboard.

[ragu ragu]

In a dashboard list of dimensions given in dropdown {Category, Subcategory and 
Product}. 
Bar chart chosen dimension is Category by default in the dashboard. End user 
can change the dimension it reflects in bar chart.