我希望用四个1‘S,然后四个2’S等等来编号我输出的行,而不管行中的值是什么.我的数据是按周排序的,所以我基本上是在try 将周分组为四个一组.
我试着看了row_number()
个,但不知道怎么做.
任何帮助感激不尽.
请注意,情况并非如此.
Week Code | Revenue | Grouping |
---|---|---|
FY23 W1 | £21,531 | 1 |
FY23 W2 | £4,927 | 1 |
FY23 W3 | £22,651 | 1 |
FY23 W4 | £5,612 | 1 |
FY23 W5 | £16,307 | 2 |
FY23 W6 | £11,824 | 2 |
FY23 W7 | £15,840 | 2 |
FY23 W8 | £37,761 | 2 |
FY23 W9 | £4,603 | 3 |
FY23 W10 | £36,549 | 3 |
FY23 W11 | £37,566 | 3 |
FY23 W12 | £29,117 | 3 |
FY23 W13 | £41,589 | 4 |
FY23 W14 | £2,910 | 4 |
FY23 W15 | £40,596 | 4 |
FY23 W16 | £3,611 | 4 |
FY23 W17 | £27,731 | 5 |
FY23 W18 | £43,338 | 5 |
FY23 W19 | £22,971 | 5 |
FY23 W20 | £42,099 | 5 |
FY23 W21 | £40,962 | 6 |
FY23 W22 | £15,621 | 6 |
FY23 W23 | £16,422 | 6 |
FY23 W24 | £44,012 | 6 |