7 Replies Latest reply: Sep 18, 2012 10:52 AM by jagan mohan rao appala

# Help in Drill down of chart

Hi,

I was trying to create Drill down group for trend please find the excel sheet for dimension that i want include to groups and drill down.....

1 level----International, Domestic, ABC, JKl

if we click international and immediate next level is ABC,DEF,GHI  and if we cick ABC next level is CAD and xyz........etc as well as for domestic also

i was trying below expression for 1st level but its not working

=if(match(GROUP1,'International','Domestic'),GROUP1) and if(match(GROUP,'ABC','JkI'),GROUP)

attached sample app also

• ###### Re: Help in Drill down of chart

Hi Anil,

PFA file.

Regards,

Jagan.

• ###### Re: Help in Drill down of chart

I see that you have created a 'Drill Down' group which has

1. Calculated Item

2. Group

3. Make

If you use 'Group1' instead of the 'Calculated Item' you will still be getting the drill down right?

Eg.,

Am I missing someting, can you please explain in detail your requirement if it is different?

• ###### Re: Help in Drill down of chart

Yes its different in drill down i want 1 level as like this International, Domestic, ABC, JKl if we drill down on any one we need next level....

here the problem is International and Domestc from one dimension and ABC and JKI are from another dimension, so how can we get these 4 values as 1st level in drill down group.

• ###### Re: Help in Drill down of chart

Here you go:

Level1:

Level2 (when I selected ABC):

Level2 (when I select International):

Sample file attached.

• ###### Re: Help in Drill down of chart

Thnx for your replay, actually this is good but in 1st level i want to diplay only these values International, Domestic, ABC, JKl.

i.e.  International, Domestic from GROUP1 Dimension

ABC. JKL from GROUP Dimension, how to restrict the if condition here..

• ###### Re: Help in Drill down of chart

In the drill down group for the first calculated item use:

=If(NUMBER=1,Group1,If((NUMBER=2) and (Group='ABC' or Group = 'JKL'),Group))

or

=If(NUMBER=1,Group1,If((NUMBER=2) and Match(Group,'ABC','JKL'),Group))

• ###### Re: Help in Drill down of chart

Hi Anil,

PFA file.

Regards,

Jagan.