How to use drill down in each chart along with dimension

[farheenayesha]

Hi,

My requirement is to have drill down in each chart with one or more dimension. Can anyone tell me if it is possible. I have to use Zone as drill down in each chart. I am trying to use it but it is giving some wierd chart as below. So, can anyone please tell how to do it?

In the below chart am using one dimension called Business Area and Zone drill down as

=if(Match(Zone,'West','Central','North_East','Mid_Atlantic','North_East'),Zone)