Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Ranks should be remain constant after applying break

hello my dear friends,

i have one requirement , i have taken objects like 'year','month','sales revenue' and rank,if i applied break on year then ranks should be remain same...

anybody please give me solution..

  

year        month           sales            Rank

2004january20022
2004february42112
2004march13524
2004april21321
2004may24518
2004june5437
2004july32513
2004august28715
2004september45110
2004october6322
2004november4529
2004december31614
2005january5248
2005february5534
2005march14223
2005april6223
2005may5446
2005june23119
2005july25416
2005august44511
2005september6661
2005october5465
2005november25117
2005december22220
Former Member
replied

Hi,

Use this.

=Rank([Sales revenue];([Year];[Month]))

Amit

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question