Set analysis ( based on another field)

[#1]

Hi,

I´m trying , using Set Analysis, to filter the information in my table

It´s possible to obtain the sum of the amounts, but only invoices not repeated.

Something like this:

   "Sum({$<DISTINCT Invoice>}Amount)"

Invoice     Amount

1                15

2                35

3                25

2                35

4                15

4                15

5                40

  TOTAL   130

Thanks

[Gysbert_Wassenaar]

sum({<Invoice={"=count(Invoice)=1"}>}Amount)

[swuehl]

Try

=Sum( Aggr( Only( Amount), Invoice))

But I would rather remodel the model to avoid the duplicate facts.

[#4]

Thanks!!!!

It works