Looking to make an expression to handle a lookup or similar.
I only have front-end access.
To keep it simple, I have these dimensions:
In a table I have [SalesName] as the only dimension and then multiple Expressions showing performance from that [SalesName].
Sometimes SalesName and ResponsibleName is not the same.
What I now would like is to make an Expression in the same table (and keeping [SalesName] as the only Dimension), looking up the [SalesName] in the [ResposibleName] Dimension and then summing up the sales? (Also including the sales, where the SalesName is different, but ResponsibleName is equal.)