我用segmentby根据第二列分段求得累计值第三列,如何实现只在该段最后一行显示累计值,而不是每一行都显示累计值?
可以参考下述代码:
x = 1 2 1 2 1 2 1 2 1 2 1 2;y = 0 0 1 1 1 2 2 1 1 3 3 2;t = table(x,y);select *, iif(isDuplicated(segment(y,false),LAST),NULL,sum(x)) as z from t context by segment(y,false)