Sum of Value with Distinct on another category

[Karineyumi]

Hey guys,

I really need your help..

I have this case:

Basicaly the Booking is the key that unites both databases (the Main database has a lot more columns then the example), and for one particular table i need to have the Sum of the Value Revenue but distincting the Bookings from the Main database.

I cannot separate the databases from each other, because I use information from the main database as well.

i tried many formulas using aggr/sum/distinct, but nothing has worked.

really appreciate your help!

thanks

[BrunPierre · Accepted solution]

Perhaps this

=Sum(Aggr(Only([Value Revenue]),Booking,[Value Revenue])

[Karineyumi]

Perfect, it worked!

Thank youuuuuuuu