on 10-29-2009 5:26 AM
现在有一张表,包含年份,城市,门店,销售额四个字段,我把年份,城市和销售额拖到报表中,然后对年份和城市进行分组,销售额按城市汇总。现在的需求是对每一年里的城市记录进行编号,结果要求如下:
编号 城市 销售
2001
1 aa 111
2 bb 222
3 cc 333
2002
1 aa 111
2 cc 333
3 dd 444
2003
1 aa 111
2 bb 222
3 dd 333
请教这个编号的公式怎么写?搞了半天了迷糊不出来。
谢谢!
解决了,汗
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
解决了,汗
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.