I want to display on a Chartthe top 5 doctors by claims and show all others as "Others" and what claims they represent Doctor1 = 50 Doctor2= 20 Doctor3= 11 Doctor4=10 Doctor5= 6 all other doctors = 3. How do I do this? BTW I am 50 years old and have been programming since 1982. I have been so blessed by those of you who offer help...I just want to say thank you for those many times that you have come to my aid.

You could do this in one of 2 ways: Source Query (Recommended)Manipulate your query (SQL or MDX) to group the other doctors into a single row. Groupping expressionAdd a column that returns the ranking of each doctor within the whole set and then change the category expression from Fields!Doctor.Value to a conditional e.g. IIf(Fields!Rank.Value <= 5, Fields!Doctor.Value, "Others") Option 2 might be usefull if use use the dataset in your report more than once. Bear in mind mind that solution 2 give RS more work to do, which rends to be slower than doing the groupping in the source query.

I have a same problem but insted of having grouping on IIf(Fields!Rank.Value <= 5, Fields!Doctor.Value, "Others") i want insted of Rank i want to use Some(Working HOurs), but in SSRS Group expression aggregate function is not allowed. SO could you please help in that

I'm sorry but I really can't understand what you mean. Can you try to describe your requirement in more detail? Perhaps with some examples or desired output?Adam Tappis. (MCSD VB6 & .NET, MCDBA SQL 2000)

I want to show TOP % 25 For sum(Field1Group) and others I want to club into single Column mention as "Other" Same as crystal.. Is it posibel to do that in SSRS