Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
you can simply make a table with:
dimension: Complexnr
expression: count(year...)
find attached