Need help in calculating Top n values

[#1]

Hello All,

here i need help again from you guys..

I have a hierarchy like this   Type--->Program-->SubProgram  now in the horizantal bar chart i need to show top 3 subprograms for each Program.

Please Please need your help in getting this done, as i have no idea on how to do that.

Thanks & Regards,

Venkat T

[jagan]

Hi Venkat,

Check attached file hope it helps you.

Regards,

Jagan.

[#3]

Hello Jagan,

Thanks for your work around.But here the trick is that i cant show Program Grp, i need to show only Top 3 SubProgrmas under each Program Grp..

Thanks & Regards,

Venkat T

[jagan]

Hi Venkat,

I think it is not possible, you need Program Grp dimension otherwise you will get the top 3 SubProgrmes overall.

Regards,

Jagan.