How to count different values based on same value in another column

[Anonymous]

Hi Community,

I have got two columns:

Complexnr ; Year of construction

3001 ; 1990

3002 ; 1993

3001 ; 1990

3003 ; 1995

3005 ; 2000

3001 ; 1991

3008 ; 2005

3001 ; 1990

3002 ; 1993

3003 ; 1995

3009 ; 2007

etc.

I would like to count rows of different construction year when Complexnr is the same.

In my example: complexnr has 2 different Years of construction.

Could anybody help me? Thanks in advance!

Grtz. Pascal

[YoussefBelloum]

Hi,

you can simply make a table with:

dimension: Complexnr

expression: count(year...)

find attached