Connecting data in straight table between two tables

[#1]

Hi,

Let's say I have two tables:

1. Main table (called: main) - this table has few fields, including: "Date_Id" and "Country_Name"

2. Second table (called: dim) - this table has few fields, including: "Date_Id" and "Country"

The tables are connected by the field "Date_Id".

I have a dynamic straight table, based on the main table.

I want to create an expression in the table with the following constraint: "Country" = "Country_Name" (Only if one "Country_Name" is selected).

I tried the following set analysis: {< Country={$(=MaxString(Country_Name)}>} but it doesn't work once I add "Country_Name" as a dimension in the straight table.

Can you help?

Thanks!

[Gysbert_Wassenaar · Accepted solution]

I don't think you can use a set analysis expression for this. Try an if statement: Sum( if(Country=Country_Name, Amount))

[#3]

Worked. Thanks!