Hello,

let's assume we'd like to get the total amount of all potentials, that are related to campaigns.
I'd like to filter by campaign name / start & end date in a dashboard.
Then, I'd like to have either a widget or something else to display the sum of all potential amounts.

If I use an SQL Query Table, I can't do a JOIN since there is no Lookup inside a field
If I use a Summary View, I can join the modules but widgets can't see the amount column
If I use a Tabular View, I can't join the modules

How to get this working?