884
Hi All,
How can I get the value so below image and my requirement (using SSRS REPORT)
The rank is a value from 1-12 with 1 being awarded to the month with the greatest ‘Average Gift Value’ and 12 being awarded to the month with the smallest ‘Average Gift Value’
*This post is locked for comments
In Report I have a static Text-box in Design(number of text-box 12) How Do I set Rank
Within SSRS you can use the RowNumber function. Use this across a scope of data that contains 1 row per month, sorted by ‘Average Gift Value’ in descending order
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (