Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts,
I need a function similar to Firstsortvalue() does in Script, for to put on a Dimension or Expression Dinamic table. like this example
My data are
Field 1 | Field 2
1 | A
1 | B
2 | D
2 | C
And I Want the result on a Dinamic Table:
Field 1 | Field 2
1 | A
2 | D
Just the first Field 2 data for Field 1
Is it Possible?
Tks Experts
Hi.
In the scripts you can use
Table1:
Load Field1 as FirstValue1,
Field2 as FirstValue2,
if(Field1=previous(Field1),0,1) as Check
resident Table
oreder by Field1;
And then select the records where the Check is 1.
Regards.
You can also try the following:
Table1:
Load rowno() as Order,
Field1,
Field2
resident Table
and then the expression would be firstsortedvalue(Field2,Order).
There's also a firstvalue() function for the script that you would use with a Group by Field1.
Regards.
Ok, But is it possible do this on an expression into a Dinamic table? or on a Dimension Calculated?
TKS Experts I using the function Maxstring()
Its Ok