LOAD Name,
Num,
numsum(Num,peek('S')) as S
FROM
[C:\Documents and Settings\11050.TCPL\Desktop\Almas\cumulative.xls]
(biff, embedded labels, table is Sheet1$);
output:
|
Name
|
Num
|
S
|
|
ABC
|
10
|
10
|
|
XYZ
|
20
|
30
|
|
DEF
|
30
|
60
|
|
GHI
|
40
|
100
|
|
JKL
|
50
|
150
|
|
MNO
|
60
|
210
|
|
PQR
|
70
|
280
|
|
STU
|
80
|
360
|
|
VWX
|
90
|
450
|
|
POP
|
100
|
550
|
(the same can be achieved using full Accumulation option for an expression in a pivot table)
mmorpg
ReplyDeleteınstagram takipci satin al
Tiktok Jeton Hilesi
TİKTOK JETON HİLESİ
antalya saç ekimi
instagram takipçi satın al
Takipci Satin Al
METİN2 PVP SERVERLAR
instagram takipçi satın al
Smm panel
ReplyDeleteSmm panel
İSİLANLARİBLOG.COM
İNSTAGRAM TAKİPÇİ SATIN AL
hirdavatci
Www.beyazesyateknikservisi.com.tr
servis
tiktok jeton hilesi