Drilldown Dimension

[#1]

Hi,

I am really confused with the drill down group behavior.

I have created a table with 3 columns.

UNIV:

Territory,

sum

Count

The above table is joined with rest of the data model based on the Territory. So, from another table

named KIT I pulled Area, Region and Territory and created a drill down group.

I created a bar chart with

dimension as a drill down group with Area, Region and Territory and

Expressions as Sum and Count from UNIV Table.

But Surprisingly the above drilldown group is not working (i.e., I cant see the area and region in Bar chart, But when I select Territory from list box its working)

Can Someone pls help me working this out!

Thanks in advance!

Rohini.M

[#2]

Yes Vishwanath

I added group by Territory to my script and joined the tables based on territory. Still the problem is same.

[vishsaggi]

Strange. Out of ideas. Will that be feasible to share your qvw file with scrambled data for a quick peek?

Scrambling Data

[#4]

Sorry Vishwanath

I cannot share my QVW file. Sorry about that

[#5]

I found the problem. I didn't use any aggregation function in expression. that's the reason Drill down didn't worked. Thank you all for your help