Skip to Content
avatar image
Former Member

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

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
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 04, 2015 at 09:59 AM

    Hi,

    Use this.

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

    Amit


    Untitled.png (44.5 kB)
    Add comment
    10|10000 characters needed characters exceeded