views and entity reference?

Just a little problem with views and entityreference, I would like to create a view with all the artists and one random painting per artist.

I've 2 contentypes, an artist(with multiple fields) and a painting(with multiple fields).

The paintings use entityreference field to be connected to an artist.
So you always need to create an artist first and then create paintings and add them to the artist.

artist 1 has paintings a, b, c,
artist 2 has paintings x, y, z,

no I would like to create a view which just 2 artworks (random) from painter 1 and painter 2.
but when i use field artist and fiels painting I get 6 rows with all the paintings that are there.

I don't know where to start here... any help would be appreciated :)