RangeSum Script for Dimension

[Anonymous]

Hi,

I need RangeSum for Category. How to build this function in my script for this table?

Final table should be

A,1,10;

A,3, 25;

D,2,5;

D,3,10

Test:

LOAD * INLINE [

    Category, K, Value  

    A, 1, 10

    A, 3, 15

    D, 2, 5

    D, 3, 5       

];

Tmp_Test:

NoConcatenate

Load

     Category,

    K,

    RangeSum(Value) as Cum

Resident Test;

[swuehl]

Please don't post the same question multiple times, it makes it hard to follow a discussion and is a waste of ressources.

RangeSum Script for Dimension