Thank you for your reply!

I now changed the expression to =CountDistinct(Fields!columnname.Value) but I get the following results:

Year Count %Var

2000 1

1

2001 1

1

1

1

2002 1

1

1

1

1

1

But I need the total per year to be added together.

Thank you!