Cumulative sum

[KNRaju105630]

Hi Community,

I'm trying to calculate cumulative sum, normal cumulative working fine, but if it is same value above shouldn't be the sum.

Example:

LOAD * INLINE [
ID, ID1, Sales
IND00000361, IND00831134, 48.6
IND00000361, IND00006002, 25.11
IND00000361, IND00861752, 24.3
IND00489427, IND00000967, 20
IND00489427, IND00000969, 8
IND01070344, IND00268817, 43.74
IND00466207, IND00466207, 68.04
IND00000256, IND01084992, 31.59
IND00000256, IND00002505, 8.1
IND00000256, IND00005230, 3.24
IND00000256, IND00129462, 2.45
];

my output should be below screen.

PFA,

[KNRaju105630]

is there any possibility to achieve this ?

Please give suggestions 

[paulwalker]

I have a similar need, did you get solution for this ?

if anyone can provide a solution it would be helpful!

[tresesco]

If([Group Total]<>Above([Group Total]), RangeSum(Above(Total Cummulative), [Group Total]),Above(Total Cummulative))