Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
can any one help me on the following issue. I have a stacked bar chart that is displaying count of branches manager wise.
my requirement is if I click on any segment of the bar chart it needs to show those branches. how can I get it.
Please find the attachment for sample data.
Thanks.
Regards
John
Hi,
Is this what u want?
Create a drill-down group with the dimensions Manager and Branch. Use that group as dimension in your chart. If you click on a bar segment you'll drill down from the manager to the brances.
Thnkas Gysbert Wassenaar,
yes your correct, I tried it ,however what I need if I select on any segment of the single bar those records I would like to show.
is there any way to get it done. is it possible?
Regards
John
The segments of the bar represent the different expressions. You can't select an expression value. Clicking on a segment will select the dimension values used to calculated the expression value. In your chart it will therefore select one manager.
Hi Ankit Mishra thanks.
your correct we can show like that but my requirement is I would like to show only if I click on I bar segment value ex: 2 it needs to show those two branches.
Regards
John
thanks Gysbert Wassenaar, I have attached one more sample file with drilldown group, which is having two fields senior manager and manager there senior manager is having 4 branches which are less than 400 sales. so if I click on value 4 , would like to see those branches will it possible.
Regards
John