running sum/count by rows

[maring28]

Hello again ,

I'm battering with my PP model, as it poses new challenges all the time, this time it's about running sum/count when there's NO DATES involved.
I've been searching the web and couldn't find anything about it.
I have the first two columns, and need to generate the third. Every time there's a "N", I need to add another +1 to the previos cell. in total, the last value in 'accumulate' column is counting the number of "N" values in the table.
Tried to use CALCULATE with EARLIER without success....
[TABLE="width: 235"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 235"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]accumulate[/TD]
[TD]indicator2[/TD]
[TD]indicator[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]0[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]1[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]0[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]0[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]1[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]1[/TD]
[TD]N[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

any suggestions would be welcomed...
Thanks alot!
Marina

 

[maring28]

it switched my columns - my original columns are indicator & indicator2
Thanks

 

[maring28]

well... Somehow I managed to guess my way with this
the solution is to add an index column, and then using EARLIER with this index column:
=CALCULATE(
sum([indicator2]),FILTER(ALL(table1),[index]<=EARLIER([index]))
)
simple now that I think of it...