Filter won't work due to indexing

[kiwiora]

I have a filter which I can't get to work because of indexing.

Tables

- Artists

- Artworks

- Invoice

- Invoice Line Items

The calc is in Artworks:

[color:blue]StatusCalc = [color:red]If(Sum(Artworks_InvoiceLineItems::Constant) ≥ "1"; "sold"; StatusTxt )

Status = StatusCalc &"¶all"

In Artists there is a portal with all of the artworks (all; sold; available)

The join is

kpArtistID_kfArtistID

gStatusJoin_Status

The problem is that Status cannot be indexed. How can I get around this??

TIA

[comment]

How about this way?

ShowSoldWorks.zip

[kiwiora]

I have managed to replicate into my db and it works awesomely. Many thanks comment.

(Now for me to get the concept straight in my head!)