how to display top 3 chart based on month selected
I have a request to create 3 bar charts on a tab. My table has branch No., Cancellatation code, Cancellation reasons, ReportMonth and Amount Canceled. Users wants the chart to always display the top 3 cancellation reasons by branches. Is it possible to do it so that monthly the charts changes to shows current months top 3 cancellation reasonscancellation reasons. I am using branch and Cancellation reason as dimension and for my expression am suming the amount of cancelled. If user select a month the should be able to see the top 3 reasons charts and those should chart by month(top 3 reasons will vary by month). Any idea?