Ranks should be remain constant after applying break

[Former Member]

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

2004	january	200	22
2004	february	421	12
2004	march	135	24
2004	april	213	21
2004	may	245	18
2004	june	543	7
2004	july	325	13
2004	august	287	15
2004	september	451	10
2004	october	632	2
2004	november	452	9
2004	december	316	14
2005	january	524	8
2005	february	553	4
2005	march	142	23
2005	april	622	3
2005	may	544	6
2005	june	231	19
2005	july	254	16
2005	august	445	11
2005	september	666	1
2005	october	546	5
2005	november	251	17
2005	december	222	20

[amitrathi239 · Accepted solution]

Hi,

Use this.

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

Amit

[Former Member · Accepted solution]

thank you very much amit..