Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
I don't think you can use a set analysis expression for this. Try an if statement: Sum( if(Country=Country_Name, Amount))
I don't think you can use a set analysis expression for this. Try an if statement: Sum( if(Country=Country_Name, Amount))
Worked. Thanks!