PB如何每个组加个序号?
PB如何每个组加个序号?
[解决办法]
- SQL code
组序号:cumulativeSum(if(a = a[-1], 0, 1) for all) group中有多个列则,写成 cumulativeSum(if(a = a[-1] and c = c[-1], 0, 1) for all)序号:GetRow()-First(GetRow() for group 1)+1
发布时间: 2012-02-04 15:43:08 作者: rapoo
PB如何每个组加个序号?
PB如何每个组加个序号?
[解决办法]
组序号:cumulativeSum(if(a = a[-1], 0, 1) for all) group中有多个列则,写成 cumulativeSum(if(a = a[-1] and c = c[-1], 0, 1) for all)序号:GetRow()-First(GetRow() for group 1)+1