Skip to Content
0
Former Member
Jan 29, 2010 at 09:41 AM

Drill Down between 2 stacked column chart with multiple rows.

17 Views

Hi,

Can anyone please help me.

1) i have to create stacked column chart with Region and cout of calls for previous 3 quarters.

2) the 2nd stacked column should display the priority with the count of calls for the respective selection of region on the 1st chart..

to achieve this,

i'm using 2 stacked column charts and 1 lebel baseb menu.

from this i can able to get the drill down from label based menu to 2nd stacked column chart but i couldn't able to done the same from 1st stacked coumn chart.

Becoz my data is multiple row for each quarter.

please suggest me to achieve the drill down between 2 stacked column charts.

assume that my data like below.:

coulmns for 1st stacked column chart : Region, Q2,Q3 &Q4

Region Q2 Q3 Q4

Other 3658 3497 497

NA - North

America 3 3 1101

APJK 1 4 597

UK 324

EMEA North 1 1 288

CORPORATE 1 5 215

LA -

Latin America1 2 208

EMEA 1 199

EMEA South 1 1 169

Coulmns for 2nd coumn chart: Region, Priority, Q2,Q3,Q4 ()which is derived from 1st table.

Region Priority Q2 Q3 Q4

Other D: End of Next Day 1568 1613 239

Other C: End of Day 983 893 119

Other A: 2 Hour 631 610 70

Other B: 4 Hour 396 318 56

NA -

North AmericaD: End of Next Day 2 2 514

APJK D: End of Next Day 3 297

NA -

North AmericaC: End of Day 284

NA -

North AmericaA: 2 Hour 1 170

UK D: End of Next Day 157

APJK C: End of Day 1 1 152

Other E: 3 - 5 Business Days 68 58 13

EMEA North D: End of Next Day 1 136

CORPORATE D: End of Next Day 4 107

NA - North America B: 4 Hour 1 104

LA - Latin America D: End of Next Day 1 1 86

EMEA D: End of Next Day 86

UK C: End of Day 85

APJK A: 2 Hour 79

EMEA South D: End of Next Day 72

EMEA North A: 2 Hour 69

EMEA North C: End of Day 56

APJK B: 4 Hour 55

EMEA C: End of Day 1 53

LA - Latin America C: End of Day 54

UK A: 2 Hour 49

EMEA South C: End of Day 1 44

CORPORATE A: 2 Hour 1 43

CORPORATE C: End of Day 44

LA - Latin America A: 2 Hour 1 42

EMEA South A: 2 Hour 1 32

EMEA B: 4 Hour 30

UK B: 4 Hour 30

EMEA A: 2 Hour 27

EMEA North B: 4 Hour 1 26

NA -

North AmericaE: 3 - 5 Business Days 25

LA - Latin America B: 4 Hour 23

EMEA South B: 4 Hour 20

CORPORATE B: 4 Hour 17

APJK E: 3 - 5 Business Days 13

Other F: 6 - 10 Business Days 6 4

Other G: 11 - 20 Business Days 6 1