How to count the number of occurences of a value in a column

I have a report, for which I want to keep track of the number of times a value is recurring.

eg.

Column A Column B Column C

A 5 0

B 3 0

A 0 1

B 1 0

C 0 2

D 0 3

So, in this example, I want Column C to keep a running count of the number of times zero occurs in Column B.

I was thinking about using a global variable and increment it whenever column B's value was 0 but I haven't a clue as to where to begin. Any help will be appreciated

Thanks

Use a conditional RunningValue in a table detail column to calculate the values as shown in column C:

=RunningValue(iif(Fields!B.Value = 0, 1, 0), Sum, Nothing)

-- Robert

|||

Thanks A million Robert!!!!

Such a simple solution, never thought of that. Thanks again.