Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have two tables
Customer and Occupation which have 1 to many relation. I want to show output as final front end table..
The following should work:
Dimension 1: ID
Dimension 2: Name
Measure: MaxString(if(Year=year(today()), Type))
I'm using the MaxString() because Only() will show a null if there is more than one value. The if() statement is needed instead of using set analysis because you still want to show the blanks.
The following should work:
Dimension 1: ID
Dimension 2: Name
Measure: MaxString(if(Year=year(today()), Type))
I'm using the MaxString() because Only() will show a null if there is more than one value. The if() statement is needed instead of using set analysis because you still want to show the blanks.