Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
データロードエディターで月々の売上データをロードし、MATの項目を追加したテーブルを作りたい
年月 | 売上 | MAT |
---|---|---|
201601 | 100 | 100 |
201602 | 100 | 200 |
201603 | 110 | 310 |
201604 | 110 | 420 |
201605 | 110 | 530 |
201606 | 120 | 650 |
201607 | 120 | 770 |
201608 | 120 | 890 |
201609 | 120 | 1010 |
201610 | 130 | 1140 |
201611 | 130 | 1270 |
201612 | 150 | 1420 |
201701 | 130 | 1450 |
201702 | 140 | 1490 |
201703 | 140 | 1520 |
201704 | 140 | 1550 |
201705 | 140 | 1580 |
201706 | 140 | 1600 |
シート(ピボットテーブル)では、rangesum(Before(Sum({$<年=>}JPM_売上金額),0,12))が使えると思いますが、同様の集計をResident Load使って、MATの項目を追加したテーブルを作る場合は、どのように記載したらよいのかご教示ください
よろしくお願いします
Hi,
Try like this,
Fact:
load *,
RangeSum(Peek('CumSales'),Sales,0) as CumSales;
LOAD * INLINE [
Month, Sales
201601, 100
201602, 100
201603, 110
201604, 110
201605, 110
201606, 120
201607, 120
201608, 120
201609, 120
201610, 130
201611, 130
201612, 150
201701, 130
201702, 140
201703, 140
201704, 140
201705, 140
201706, 140
];
Hi,
Try like this,
Fact:
load *,
RangeSum(Peek('CumSales'),Sales,0) as CumSales;
LOAD * INLINE [
Month, Sales
201601, 100
201602, 100
201603, 110
201604, 110
201605, 110
201606, 120
201607, 120
201608, 120
201609, 120
201610, 130
201611, 130
201612, 150
201701, 130
201702, 140
201703, 140
201704, 140
201705, 140
201706, 140
];
Devarasu-san
Thanks for your infomation.
I will try.