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.
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.
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.
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.
