many thanks for your reply:
I have two tables: Tab_1 and Tab_2
Tab_1.Capture Point Value
Costs 5 Other 2
1) unlinked/Qualified (Very Important)
2) was created as an inline table
Tab_2.Capture Point Costs Other
I have inserted a straight table in qv - the dimensions of which are those from Tab_2.
I would like to sum from Tab_1 where values in Tab_1.Capture Point = values in the straight table (Tab_2.Capture Point)
I would prefer to use the expression builder as a means of achieving this - basically, i need a sumif(tab_1.Capture Point,tab_2.capture point,tab_1.value)
I would rather link both tables (or join them), so you can solve your table dimension filtering by just using the data model.
(there are other methods to show all values, even when you made selections, using set analysis).
But even if you don't change your data model, using Tab_2.Capture Point as dimension and this as expression
=Sum(If([Tab_2.Capture Point] = [Tab_1.Capture Point], Value))
Tab_2.Capture Point Sum(If([Tab_2.Capture Point] = [Tab_1.Capture Point], Value)) 7 Costs 5 Other 2