Top 5

[master_student]

Hi guys,

I need to display the top 5 amount without using sum function. My expression is : sum(  {< [Year of date]=, [Month of date]=, [Day of date]=,Dis_name =>} BALANCE/1000) because the amounts are wrong using the sum function.

a print screen of my graph :

Is that possible?

Thanks in advance

[sunny_talwar]

What exactly are you trying to do? May be use Only? I don't know much to offer much suggestions...

[jonathandienst]

I think you need to explore why the number is wrong using the sum function. Working around may be treating the symptom, but not the underlying cause.

Anyway, it is not possible to make suggestions without a lot more information.I suggest that you post your qvw, or a sample that illustrates the problem.

[#4]

As Jonathan mentioned, tough to diagnose without more information...but assuming you do figure out your SUM issue I believe you can achieve the top 5 using Dimension Limits.  In your case you would restrict the values displayed by showing only the largest 5.

[master_student]

I don't know but by using the sum function in the expression. The amounts displayed are not correct. I just need to display the amount like they in the database and use only the num function : =num(BALANCE/1000, '# ##0')

Thanks a lot

[master_student]

I already created my top 5 graph using dimension limit but the pb is that with the sum function the amounts are too big.

[susovan]

Hi,

You can try this,

[sunny_talwar]

Have you tried this:

=Num(Only({<[Year of date], [Month of date], [Day of date],Dis_name>} BALANCE/1000), '# ##0')

[master_student]

Hi Sunny,

it didn't work