CODEWITHSUNDEEP
sql-serverreporting-servicesssrs-2012rankingssrs-tablix
Raj
Raj

Reputation: 23

Add rank for each row group as a new column in SSRS

In SSRS I am trying to add a rank as a new column and ranking should be based of "New Deals(#)" field. Also ranking should start from 1 for every Region. Please see the screen shot for reference. I don't want the ranking to be done on stored Procedure, so could someone suggest me a way to have a rank on SSRS based off of a filed inside a row group.

Desired Output format

Design View

Upvotes: 0

Views: 1756

Answers (1)

Wes H
Wes H

Reputation: 4439

Use an expression in the field

=RowNumber("Your Region Group Name Here")

That will generate a new row number sequence for each region. The number assigned will be based on the sort order of the group.

Of course you would not be able to use this row number to order your data.

Incidentally, the best way to do this would be in the stored procedure. That way it becomes part of your data, allowing you to sort the region by another field (name perhaps) without changing the rankings assigned.

Upvotes: 1

Related Questions